Below query can be used to find identity tables in Sybase database.

1> select @@servername 'Server',db_name() 'DB',convert(char(35),object_name(id)) as "Table_Name", convert(char(35),name) as "Column_Name" from syscolumns where status=128
2> go

Sample output:

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.