Attributes Property

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

The Attributes property exposes various properties of a referenced table.

Sintaxis

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.

Applies To:

Table Object