3> CREATE TABLE customer
4> (
5> cust_id int NOT NULL IDENTITY PRIMARY KEY,
6> cust_name varchar(50) NOT NULL
7> )
8> GO
1>
2> CREATE TABLE orders
3> (
4> order_id int NOT NULL IDENTITY PRIMARY KEY,
5> cust_id int NOT NULL REFERENCES customer(cust_id)
6> ON UPDATE NO ACTION ON DELETE NO ACTION
7> )
8> GO
1>
2>