Mega Code Archive

 

Categories / MSSQL Tutorial / Sequence Indentity

 

Supported data types for the IDENTITY property are TinyInt, SmallInt Int, BigInt, Decimal, and Numeric

8> 9> CREATE TABLE MyTable ( 10> MyID Int IDENTITY(1000000, -100) NOT NULL 11> ,MyDescription NVarChar(50) NOT NULL ) 12> GO 1> 2> drop table MyTable; 3> GO