Sybase ADDICT

select object_name(id) as "tablename",name as "column_name"
from syscolumns where status =128
go

Tags: ase, howto, sql, sybase, Sybase Adaptive Server Enterprise, tips, transact-sql

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.

Sorry, the comment form is closed at this time.