4>
5> CREATE TABLE MyTable (
6> key_col int NOT NULL IDENTITY (1,1),
7> abc char(1) NOT NULL
8> )
9> INSERT INTO MyTable VALUES ('a')
10> INSERT INTO MyTable VALUES ('b')
11> INSERT INTO MyTable VALUES ('c')
12> SELECT * FROM MyTable ORDER BY key_col
13>
14>
15> SELECT
16> IDENT_SEED ('MyTable') AS seed,
17> IDENT_INCR ('MyTable') AS increment
18>
19> drop table MyTable
20> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
key_col abc
----------- ---
1 a
2 b
3 c
(3 rows affected)
seed increment
---------------------------------------- ----------------------------------------
1 1
(1 rows affected)
1>