SUPPLIER, Sql Server

Language: Layout:

CREATE TABLE SUPPLIER(

supplier_id VARCHAR(5)  PRIMARY KEY,
supplier_name VARCHAR(20) NOT NULL,
address VARCHAR(30),
email VARCHAR(30),
phone_number CHAR(12),
);

INSERT INTO SUPPLIER VALUES ('c234', 'john carten', '59 sandmere avenue','johncarten@gmail.com', '3658887458');
INSERT INTO SUPPLIER VALUES ('c456', 'dean ambros', '45 brookland blvd', 'deanambros@gmail.com', '7854445695 ');
INSERT INTO SUPPLIER VALUES ('c231', 'roman regins', '221 autum blvd', 'romanregin@gmail.com', '1236987542');
INSERT INTO SUPPLIER VALUES ('c599', 'seth rollins','54 sandalwood avenue', 'sethrollins@gmail.com', ' 7895462185');
INSERT INTO SUPPLIER VALUES ('c221', 'brock lenser', '67 springforest square', 'brocklenser@gmail.com', ' 4569875698');
INSERT INTO SUPPLIER VALUES ('c445', 'rock smith', '23 yorkland blvd', 'rocksmith@gmail.com', '4569875212 ');
INSERT INTO SUPPLIER VALUES ('c238', 'william shakes', '64 sandmere avenue', 'williamshakes@gmail.com', '9815672593 ');
INSERT INTO SUPPLIER VALUES ('c220', 'chrestler', '67 springforest square', 'chrestler@gmail.com', '4569875698 ');
INSERT INTO SUPPLIER VALUES ('c554', 'james collins', '90 sandalwood avenue', 'jamescollins@gmail.com', '8283039555 ');
INSERT INTO SUPPLIER VALUES ('c111', 'jean ambros', '89 brookland blvd', 'jeanambros@gmail.com', ' 7854445095');

SELECT * FROM SUPPLIER;

View schema
Execution time: 0 sec, rows selected: 10, rows affected: 10, absolute service time: 0,17 sec