>Hi,
>
>What would be the TSQL syntax to check if a column is set to be an Indenity column (Is Identity = Yes)? And if No, how to do set the column in Identity Yes in code?
>
>TIA

Sys.columns has IsIdentity bit column, e.g.

if exists (SELECT name, is_identity
FROM sys.columns
WHERE [object_id] = object_id('items')
and is_identity = 1)

print 'Table Items has identity column'

(If you know the column name, just check it using a similar script).

If you want to make the column to be identity, you need to re-create the table (e.g. if you don't want to preserve current values, you can do

select identity (int,1,1) as NewIdentityColumn, col1, col2, ... 
into myNewTable
from myTable