sys.foreign_keys (Transact-SQL)
Contains a row per object that is a FOREIGN KEY constraint, with sys.object.type = F.
| Column name | Data type | Description |
|---|---|---|
|
<Columns inherited from sys.objects> |
|
For a list of columns that this view inherits, see sys.objects (Transact-SQL). |
|
referenced_object_id |
int |
ID of the referenced object. |
|
key_index_id |
int |
ID of the key index within the referenced object. |
|
is_disabled |
bit |
FOREIGN KEY constraint is disabled. |
|
is_not_for_replication |
bit |
FOREIGN KEY constraint was created by using the NOT FOR REPLICATION option. |
|
is_not_trusted |
bit |
FOREIGN KEY constraint has not been verified by the system. |
|
delete_referential_action |
tinyint |
The referential action that was declared for this FOREIGN KEY when a delete happens. 0 = No action 1 = Cascade 2 = Set null 3 = Set default |
|
delete_referential_action_desc |
nvarchar(60) |
Description of the referential action that was declared for this FOREIGN KEY when a delete occurs: NO_ACTION CASCADE SET_NULL SET_DEFAULT |
|
update_referential_action |
tinyint |
The referential action that was declared for this FOREIGN KEY when an update happens. 0 = No action 1 = Cascade 2 = Set null 3 = Set default |
|
update_referential_action_desc |
nvarchar(60) |
Description of the referential action that was declared for this FOREIGN KEY when an update happens: NO_ACTION CASCADE SET_NULL SET_DEFAULT |
|
is_system_named |
bit |
1 = Name was generated by the system. 0 = Name was supplied by the user. |
Reference
Catalog Views (Transact-SQL)Object Catalog Views (Transact-SQL)
