Thanks Sergey,

I modified it a bit as follows:

SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
	WHERE (COLUMNPROPERTY(OBJECT_ID(table_name), column_name, 'IsIdentity') > 0)
	and (COLUMN_NAME = 'TransactionDetailsID')

If it returns 1, then the column is an identity column.


>Try

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
>	WHERE COLUMNPROPERTY(OBJECT_ID(table_name), column_name, 'IsIdentity') > 0
>

>
>>I need to query either an INFORMATION_SCHEMA view or system table to determine if a field in a table is an identity field.
>>
>>
>>INFORMATION_SCHEMA.COLUMNS doesn't seem to be the answer (unless I'm reading it wrong...).
>>
>>Does anyone know if this information can be obtained from a INFORMATION_SCHEMA view?
>>
>>If not, how should I go about obtaining this information?
>>
>>Thanks in advance, Al