Thanx,Since there is only one autoincrement column per table, you can use SELECT
IDENT_CURRENT('table_name') news:8bf47d13-a87f-4304-b0d6-9eae8685e164@.discussions.microsoft.com... > It seems MS changed the way syscolumns table works. It appears this is > no longer a table, but probably a systemview. Problem is, it looks like > the autoval column is no longer working. I was using this to determine > whether a column was an auto incrementing identity field. How should I > go about determining a column's auto increment values? > > Thanx, >|||Have you tried Tim SCOLUMNPROPERTY ( id , column , property )
IsIdentity
using
No comments:
Post a Comment