All databases
sysobjects contains one row for each table, view, stored procedure, extended stored procedure, log, rule, default, trigger, check constraint, referential constraint, computed column, function-based index key, and (in tempdb only) temporary object, and other forms of compiled objects. It also contains one row for each partition condition ID when object type is N.
The columns for sysobjects are:
Name |
Datatype |
Description |
---|---|---|
name |
varchar(255) not null |
Object name. |
id |
int |
Object ID. |
uid |
int |
User ID of object owner. |
type |
char(2) |
One of the following object types:
|
userstat |
smallint |
Application-dependent type information (32768 decimal [0x8000 hex] indicates to Data Workbench® that a procedure is a report). |
sysstat |
smallint |
Internal status information (256 decimal [0x100 hex] indicates that table is read-only) |
indexdel |
smallint |
Recounts the changes in the schema of an object and and updates schemacnt. |
schemacnt |
smallint |
Count of changes in the schema of an object (incremented if a rule or default is added) |
sysstat2 |
int |
Additional internal status information (see Table 1-17) |
crdate |
datetime |
Date the object was created |
expdate |
datetime |
Reserved |
deltrig |
int |
Stored procedure ID of a delete trigger if the entry is a table. Table ID if the entry is a trigger. |
instrig |
int |
Stored procedure ID of a table’s insert trigger if the entry is a table |
updtrig |
int |
Stored procedure ID of a table’s update trigger if the entry is a table |
seltrig |
int |
Reserved |
ckfirst |
int |
ID of first check constraint on the table |
cache |
smallint |
Reserved |
audflags |
int null |
Object’s audit settings |
objspare |
int |
Spare |
versionts |
binary(6) null |
The version timestamp of the last schema change for this object (used by Replication Server) |
loginame |
varchar(30) null |
Login name of the user who created the object |
identburnmax |
numeric(17) null |
Maximum burned value for identity column if any in this object |
spacestate |
smallint null |
For internal use only |
erlchgts |
binary(8) null |
For internal use only |
Table 1-17 lists the bit representations for the sysstat2 column:
Unique clustered index on id
Nonclustered index on name, uid
Copyright © 2005. Sybase Inc. All rights reserved. |