DotNetShoutout - Find tables with identity columns in Sybase ASE

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

8
Shouts

Shout it

Find tables with identity columns in Sybase ASE

published 872 days, 7 hours, 12 minutes ago posted by

SybaseAddict 874 days, 5 hours, 16 minutes ago

Quickly find out the database’s tables having identity columns:

1> select objectname(id) as "tablename",name as "columnname"

2> from syscolumns where status =128

3> go

Enjoy

category: SQL | clicked: 0 | | source: sybase-addict.com | show counter code

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout