sys.sysobjects (Transact-SQL)
Contains one row for each object that is created within a database, such as a constraint, default, log, rule, and stored procedure.
 Important: |
|---|
| This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. To find the equivalent system view or views, see Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. |
| Column name | Data type | Description | |
|---|---|---|---|
|
name |
sysname |
Object name | |
|
id |
int |
Object identification number | |
|
xtype |
char(2) |
Object type. For a list of valid object types, see sys.objects. | |
|
uid |
smallint |
Schema ID of the owner of the object. For databases upgraded from an earlier version of SQL Server, the schema ID is equal to the user ID of the owner.
Overflows or returns NULL if the number of users and roles exceeds 32,767. For more information, see Querying the SQL Server System Catalog. | |
|
info |
smallint |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. | |
|
status |
int |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. | |
|
base_schema_ver |
int |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. | |
|
replinfo |
int |
Reserved for use by replication. | |
|
parent_obj |
int |
Object identification number of the parent object. For example, the table ID if it is a trigger or constraint. | |
|
crdate |
datetime |
Date the object was created. | |
|
ftcatid |
smallint |
Identifier of the full-text catalog for all user tables registered for full-text indexing, and 0 for all user tables that are not registered. | |
|
schema_ver |
int |
Version number that is incremented every time the schema for a table changes. Always returns 0. | |
|
stats_schema_ver |
int |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. | |
|
type |
char(2) |
Object type. For a list of valid object types, see sys.objects. | |
|
userstat |
smallint |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. | |
|
sysstat |
smallint |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. | |
|
indexdel |
smallint |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. | |
|
refdate |
datetime |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. | |
|
version |
int |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. | |
|
deltrig |
int |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. | |
|
instrig |
int |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. | |
|
updtrig |
int |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. | |
|
seltrig |
int |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. | |
|
category |
int |
Used for publication, constraints, and identity. | |
|
cache |
smallint |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
