Originally posted by fattyacid
does anyone know how sql 2k stores whether a column is an identity column? is it in any system tables or information_schema?
i've read that i can't find the next value of the identity, which i find weird. I just want to know if the column is an identity or not.
Thanks in advance.
Bitmap used to describe a property of the column or the parameter:
0x08 = Column allows null values.
0x10 = ANSI padding was in effect when varchar or varbinary columns were added. Trailing blanks are preserved for varchar and trailing zeros are preserved for varbinary columns.
0x40 = Parameter is an OUTPUT parameter.
0x80 = Column is an identity column.