The less code the better - thanks Sergey.

>If you know table and column name than you don't need INFORMATION_SCHEMA.

SELECT COLUMNPROPERTY(OBJECT_ID('mytable'), 'TransactionDetailsID', 'IsIdentity')

>