Attributes Property (SQL-DMO)

The Attributes property exposes various properties of a referenced table.

Applies To

Table Object

Syntax

object.Attributes

Part Description
object Expression that evaluates to an object in the Applies To list

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
SQLDMOTabAtt_HasConstraint 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
SQLDMOTabAtt_SystemObject 2 Referenced table is a Microsoft® SQL Server™ system object
SQLDMOTabAtt_Unique 1024 Referenced table has at least one UNIQUE constraint

Data Type

Long, enumerated

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetAttributes(LPLONG pRetVal);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.