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
|