Sybase ADDICT

Find tables with identity columns

May 23rd, 2009 @ 9:28 PM by Jean-Francois LEBON | 1 Comment
Quickly find out the database’s tables having identity columns:
```
select object_name(id) as "tablename",name as "column_name"
from syscolumns where status =128
go
```
Enjoy
Tags: ase, howto, sql, sybase, Sybase Adaptive Server Enterprise, tips, transact-sql
Previous post

Next post
1 Comment »
1. Find tables with identity columns in Sybase ASE…
  
  Thank you for submitting this cool story – Trackback from DotNetShoutout…
  
  Trackback by DotNetShoutout — January 3, 2010 @ 1:30 AM
RSS feed for comments. TrackBack URL

Something to say ? Leave a comment...

You must be logged in to post a comment.