Table Attribute Constants (SQLDMO_TABLEATT_TYPE)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Table attribute constants describe, roughly, a Microsoft SQL Server table. For example, the Attributes property of a Table object referencing a table on which a primary key is defined returns SQLDMOTabAtt_PrimaryKey. Information about the primary key, its member columns, and construction, can be determined by using the Keys collection of the Table object.

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 an active subscription.
SQLDMOTabAtt_Replicated	64	The referenced table is actively subscribed to a Publisher.
SQLDMOTabAtt_SystemObject	2	The referenced table is a SQL Server system object.
SQLDMOTabAtt_Unique	1024	The referenced table has at least one UNIQUE constraint.