IDENTITY as PRIMARY KEY : IDENTITY « Sequence « SQL Server / T-SQL

1. SQL Server / T-SQL
2. Sequence
3. IDENTITY

IDENTITY as PRIMARY KEY

 

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>

 

Related examples in the same category