Attributes Property
未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。
The Attributes property exposes various properties of a referenced table.
語法
object.Attributes
Parts
- object
An expression that evaluates to an object in the Applies To list.
Data Type
Long, enumerated
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetAttributes(LPLONG pRetVal);
Returns
The Attributes property returns a bit-packed value unpacked using these values.
Constant |
Value |
Description |
|---|---|---|
SQLDMOTabAtt_Check |
128 |
The referenced table has at least one integrity constraint. |
SQLDMOTabAtt_Default |
2048 |
The referenced table has at least one DRI (Declarative Referential Integrity) default defined. |
SQLDMOTabAtt_ForeignKey |
4 |
The referenced table has at least one foreign key. |
SQLDMOTabAtt/HasConstraint |
7300 |
The referenced table has at least one DRI constraint. |
SQLDMOTabAtt_Identity |
1 |
The referenced table has a column exposing the identity property. |
SQLDMOTabAtt_PrimaryKey |
512 |
The referenced table has a primary key. |
SQLDMOTabAtt_Published |
32 |
The referenced table is published for replication. |
SQLDMOTabAtt_Referenced |
8 |
The referenced table is referenced by at least one other table's foreign key. |
SQLDMOTabAtt_ReplCheck |
4096 |
The referenced table has at least one integrity constraint not fired when replicated data is inserted. |
SQLDMOTabAtt_Replica |
256 |
At least one Subscriber has referenced the table's publication. |
SQLDMOTabAtt_Replicated |
64 |
The referenced table is actively subscribed to a Publisher. |
SQLDMOTabAtt/SystemObject |
2 |
The referenced table is a Microsoft SQL Server system object. |
SQLDMOTabAtt_Unique |
1024 |
The referenced table has at least one UNIQUE constraint. |