8> CREATE TABLE department(
9> dept_no CHAR(4) NOT NULL,
10> dept_name CHAR(25) NOT NULL,
11> location CHAR(30) NULL)
12> GO
1>
2> ALTER TABLE department
3> ALTER COLUMN location CHAR(25) NOT NULL
4> GO
1>
2> drop table department;
3> GO
1>