Post reply

IDENTITY Info in System Catalog

  • July 29, 2003 at 2:36 pm

    #83942

    Whether a column is an IDENTITY is defined by the flag 0x80 in the syscolumns.status column.

    But I cannot find IDENTITY seed and increment information in the system catalog. Where are those stored?

    Thanks.

    Michael

  • July 29, 2003 at 2:44 pm

    #467600

    Never mind, found it. It is IDENT_SEED( 'table_name' )

    Thanks.

  • July 29, 2003 at 2:54 pm

    #467604

    But how do I figure out if seed and increment were specified explicitly or not?

    For example,

    CREATE TABLE tbl_1 ( col_1 INT IDENTITY )

    versus

    CREATE TABLE tbl_1 ( col_1 INT IDENTITY( 1, 1 ) )

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply