The Attributes property exposes various properties of a referenced table.
object.Attributes
object
Expression that evaluates to an object in the Applies To list
Long, enumerated
Read-only
HRESULT GetAttributes(LPLONG pRetVal);
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. |