1>
2> CREATE TABLE department(dept_no CHAR(4) NOT NULL,
3> dept_name CHAR(25) NOT NULL,
4> location CHAR(30) NULL)
5>
6> insert into department values ('d1', 'developer', 'Dallas')
7> insert into department values ('d2', 'tester', 'Seattle')
8> insert into department values ('d3', 'marketing', 'Dallas')
9>
10>
11>
12>
13> -- Get full details of all departments.
14>
15> SELECT * from department
16> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
dept_no dept_name location
------- ------------------------- ------------------------------
d1 developer Dallas
d2 tester Seattle
d3 marketing Dallas
(3 rows affected)
1>
2> drop table department
3> GO