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 Description
name sysname Object name.
Id int Object identification number.
xtype char(2) Object type. Can be one of these object types:

C = CHECK constraint
D = Default or DEFAULT constraint

brucebin 發表在 痞客邦 留言(0) 人氣()