Hai,
    Can any one help me to check weather the column is identity or not.
           thanks
            Vamsi.

vamsi

__________________
vamsi Krishna G
mobile: 91 + 9986023966.
124 Puttappa layout new Tippasandhra,
bangalore.
Inida

yep, right here ( http://sqlservercode.blogspot.com/20...ty-column.html )

------------------------------------------ http://sqlservercode.blogspot.com/

You can determine if a column is an identity using the COLUMNPROPERTY, as follows:

SELECT COLUMNPROPERTY( OBJECT_ID('YourTable'),'YourColumn', 'IsIdentity')

If this returns a value of 1, the column is an identity column.

SQL Server Helper
http://www.sql-server-helper.com