SQL-DMO
Attributes Property
The Attributes property exposes various properties of a referenced table.
Applies To
| Table Object |
Syntax
object.Attributes
Parts
object
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 | Referenced table has at least one integrity constraint. |
| SQLDMOTabAtt_Default | 2048 | Referenced table has at least one DRI default defined. |
| SQLDMOTabAtt_ForeignKey | 4 | Referenced table has at least one foreign key. |
| SQLDMOTabAttHasConstraint | 7300 | Referenced table has at least one DRI constraint. |
| SQLDMOTabAtt_Identity | 1 | Referenced table has a column exposing the identity property. |
| SQLDMOTabAtt_PrimaryKey | 512 | Referenced table has a primary key. |
| SQLDMOTabAtt_Published | 32 | Referenced table is published for replication. |
| SQLDMOTabAtt_Referenced | 8 | Referenced table is referenced by at least one other table's foreign key. |
| SQLDMOTabAtt_ReplCheck | 4096 | 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 | Referenced table is actively subscribed to a Publisher. |
| SQLDMOTabAttSystemObject | 2 | Referenced table is a Microsoft® SQL Server™ system object. |
| SQLDMOTabAtt_Unique | 1024 | Referenced table has at least one UNIQUE constraint. |