sysobjects

Provides information about every object in the database, such as tables, views, stored procedures, triggers, and constraints.

Name Datatype Description
name varchar(255) not null A database object name.
id int The object ID.
uid int The user ID of the object owner.
type char(2) The object type ID.
The possible values are:
  • C – A computed column.
  • D – A default object.
  • DD – A decrypt default.
  • EK – An encryption key.
  • F – A SQLJ function.
  • N – A partition condition.
  • IT – An INSTEAD OF trigger.
  • P – A Transact-SQL or SQLJ stored procedure.
  • PP – The predicate of a privilege.
  • PR – A prepare object created using dynamic SQL.
  • R – A rule object.
  • RI – A referential constraint.
  • RS – A precomputed result set.
  • S – A system table.
  • SF – A scalar or user-defined function.
  • SQ – A sequence object.
  • TR – A trigger.
  • U – A user table.
  • V – A view.
  • XP – An extended stored procedure.
userstat smallint Application-specific status information.
32768 (0x8000) – A report procedure in Data Workbench.
sysstat smallint Internal system status information.
256 (0x100) – A read-only table.
indexdel smallint A counter used to track schema changes and trigger updates to the schemacnt value.
schemacnt smallint The number of schema changes to the object. The value increases when adding objects such as rules or defaults.
sysstat2 int Additional internal system status information maintained by the database engine.
sysstat3 unsigned smallint Additional internal status flags used by the system.
crdate datetime The date and time when the object was created.
expdate datetime Reserved for future use.
deltrig int The stored procedure ID of the delete trigger if the entry is a table. If the entry is a trigger, the field contains the associated table ID.
instrig int The stored procedure ID of the insert trigger associated with the table.
updtrig int The stored procedure ID of the update trigger associated with the table.
seltrig int Reserved for future use.
ckfirst int The object ID of the first check constraint defined on the table.
cache smallint Reserved for internal system use.
audflags int null The audit settings configured for the object.
objspare smallint Reserved for internal system use.
versionts binary(6) null The timestamp of the most recent schema change for the object. The value is used by Replication Server.
loginame varchar(30) null The login name of the user who created the object.
identburnmax numeric(38,0) null The maximum burned identity value associated with the object if it contains an identity column.
spacestate smallint null Reserved for internal system use.
erlchgts binary(8) null Reserved for internal system use.
lobcomp_lvl tinyint The compression level applied to large object (LOB) data associated with the object.
status5 int Additional internal system status information.