Identity Property: SELECT IDENT_SEED('customer'), IDENT_INCR('customer') : IDENT_SEED « Sequence Indentity « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Sequence Indentity
3. IDENT_SEED

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