全部博文(151)
2011年(151)
分类: WINDOWS
2011-05-04 12:59:29
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 |
uid | smallint | User ID of owner object. |
info | smallint | Reserved. For internal use only. |
status | int | Reserved. For internal use only. |
base_schema_ ver | int | Reserved. For internal use only. |
replinfo | int | Reserved. For use by replication. |
parent_obj | int | Object identification number of parent object (for example, the table ID if 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 not registered. |
schema_ver | int | Version number that is incremented every time the schema for a table changes. |
stats_schema_ ver | int | Reserved. For internal use only. |
type | char(2) | Object type. Can be one of these values:
C = CHECK constraint |
userstat | smallint | Reserved. |
sysstat | smallint | Internal status information. |
indexdel | smallint | Reserved. |
refdate | datetime | Reserved for future use. |
version | int | Reserved for future use. |
deltrig | int | Reserved. |
instrig | int | Reserved. |
updtrig | int | Reserved. |
seltrig | int | Reserved. |
category | int | Used for publication, constraints, and identity. |
cache | smallint | Reserved. |