Self-Referencing Tables : REFERENCES « Constraints « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Constraints
3. REFERENCES

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