Sequence Indentity MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Sequence Indentity
  4. 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