Mega Code Archive
Generating IDENTITY values
4> IF EXISTS ( SELECT name
5> FROM sysobjects
6> WHERE name = N'Players'
7> AND type = 'U'
8> )
9> DROP TABLE Players
10> GO
1>
2> create table Players (
3> Id int IDENTITY (1, 1) NOT NULL
4> )
5> GO
1>
2> drop table Players
3> GO
1>