Thanx,Since there is only one autoincrement column per table, you can use SELECT IDENT_CURRENT('table_name') Tim S
> 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 COLUMNPROPERTY ( id , column , property )
IsIdentity
using
Monday, March 19, 2012
Changes in SQL2005 syscolumns table
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?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment