identity in system tables

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.SELECT COLUMNPROPERTY( OBJECT_ID('table_name'),'column_name','IsIdentity' )|||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.

syscolumns:
status

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.|||Originally posted by Enigma
SELECT COLUMNPROPERTY( OBJECT_ID('table_name'),'column_name','IsIdentity' )

would you happen to know where sql 2k stores this information?|||Syscolumns

See post by snail above|||thank you