4> CREATE TABLE employee
5> (
6> emp_id int NOT NULL PRIMARY KEY,
7> emp_name varchar(30) NOT NULL,
8> mgr_id int NOT NULL REFERENCES employee(emp_id)
9> )
10> GO
1>
2> INSERT employee VALUES (1, 'Chris Smith', 1)
3> GO
(1 rows affected)
1>
2>
3> drop table employee;
4> GO