views:

376

answers:

2

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?

A: 

Use COLUMNPROPERTY . For ur reference

a) COLUMNPROPERTY (Transact-SQL)

b) Identity Columns

priyanka.sarkar
COLUMNPROPERTY function is not available in SQL CE Compact 3.5. Here is the link for your reference:http://msdn.microsoft.com/en-us/library/ms174077.aspx
rxm0203