SQL CE Compact 3.5 Identity columns for a table.

Question

Is there a query I can write against an INFORMATION_SCHEMA or against the system tables to determine if a column is an identity column in SQL CE version 3.5?

Answer 1

Use COLUMNPROPERTY . For ur reference

a) COLUMNPROPERTY (Transact-SQL)

b) Identity Columns

Answer 2

Here is the web link to the answer:

http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/f0a5b6ef-9375-4af2-9a17-34db3ca700bd?prof=required&lc=1033