Mega Code Archive

 

Categories / MSSQL / Table

 

Drop a table if necessary

1> 2> CREATE TABLE department(dept_no   CHAR(4) NOT NULL, 3>                         dept_name CHAR(25) NOT NULL, 4>                         location  CHAR(30) NULL) 5> GO 1> 2> insert into department values ('d1', 'developer',   'Dallas') 3> insert into department values ('d2', 'tester',      'Seattle') 4> insert into department values ('d3', 'marketing',  'Dallas') 5> GO (1 rows affected) (1 rows affected) (1 rows affected) 1> 2> select * from department 3> GO dept_no dept_name                 location ------- ------------------------- ------------------------------ d1      developer                 Dallas d2      tester                    Seattle d3      marketing                 Dallas (3 rows affected) 1> 2> drop table department 3> GO 1>