Mega Code Archive

 

Categories / MSSQL Tutorial / Sequence Indentity

 

Identity Property

6>  CREATE TABLE customer 7> ( 8> cust_id      smallint        IDENTITY  NOT NULL, 9> cust_name    varchar(50)     NOT NULL 10> ) 11> GO 1> 2> SELECT IDENT_SEED('customer'), IDENT_INCR('customer') 3> GO ---------------------------------------- ----------------------------------------                                        1                                        1 (1 rows affected) 1> 2> 3> drop table customer; 4> GO