This is an old revision of the document!

Sysobject SQL

Code snippets that get useful information out of the sysobjects table.

Sysobjects.type	Meaning
C	computed column
D	default
F	SQLJ function
L	log
N	partition condition
P	Transact-SQL or SQLJ procedure
PR	prepare objects (created by Dynamic SQL)
R	rule
RI	referential constraint
S	system table
TR	trigger
U	user table
V	view
XP	extended stored procedure

Note: This is from Sybase reference info.

All User Tables

SELECT sysobjects.name AS TableName
       , *
FROM   sysobjects
WHERE  sysobjects.type = 'U'

All Columns from User Tables

SELECT sysobjects.name AS TableName
       , syscolumns.name AS ColumnName
       , *
FROM   sysobjects
JOIN   syscolumns ON syscolumns.id = sysobjects.id
WHERE  sysobjects.type = 'U'

All Identity Columns from User Tables

SELECT sysobjects.name AS TableName
       , syscolumns.name AS ColumnName
       , *
FROM   sysobjects
JOIN   syscolumns ON syscolumns.id = sysobjects.id
WHERE  sysobjects.type = 'U'
AND    syscolumns.status >= 128

code snippet, sql, sysobjects

Stephen's Wiki

Table of Contents

Sysobject SQL

All User Tables

All Columns from User Tables

All Identity Columns from User Tables