Compartir a través de


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