sysobjects
Contains one row for each object (constraint, default, log, rule, stored procedure, and so on) created within a database. In tempdb only, this table includes a row for each temporary object.
Column name Data type Descriptionname | sysname | Object name. |
Id | int | Object identification number. |
xtype | char(2) | Object type. Can be one of these object types:
C = CHECK constraint |