| title | sys.foreign_keys (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.foreign_keys (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 03/15/2017 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| ms.custom |
|
||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | >=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric || =fabric-sqldb |
[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricdw-fabric]
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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ