sys.edge_constraints (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains one row for each object that is an edge constraint.

Column name Data type Description
<Columns inherited from sys.objects> For a list of columns that this view inherits, see sys.objects (Transact-SQL).
is_disabled bit 1 = Edge constraint is disbled.

0 = Edge constraint is enabled.
is_not_trusted bit 1 = Edge constraint has not been verified by the system.

0 = Edge constraint has been verified by the system.
delete_referential_action tinyint Referential action that was defined on this edge constraint.

0 = No Action.
delete_referential_action_desc nvarchar(60) Description of the referential action that was defined on this edge constraint.

NO_ACTION
is_system_named bit 1 = Edge constraint name was generated by the system.

0 = Edge constraint name was supplied by the user.

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See Also

Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ