Gar,

I don't know of a simple answer. It's easy to tell if a table has an IDENTITY column using OBJECTPROPERTY(id, TableHasIdentity) (Use OBJECT_ID() to return the id of a given database object.)

OK, check out the definition of syscolumns in the BOL. The 0x80 bit of the Status column indicates that the column has the IDENTITY property set.

Another option would be to use the Profiler to get the query that the SEM uses to load a table into the table designer.

BTW, why do you want to dynamically determine which column has the IDENTITY property set?

Good luck!

-Mike