Contains one row for each foreign constraint owned by the current user in the current database. The INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS view is based on the sysreferences, sysindexes, and sysobjects system tables.
To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA view_name.
| Column name | Data type | Description |
|---|---|---|
| CONSTRAINT_CATALOG | nvarchar(128) | Constraint qualifier. |
| CONSTRAINT_SCHEMA | nvarchar(128) | Constraint owner. |
| CONSTRAINT_NAME | sysname | Constraint name. |
| UNIQUE_CONSTRAINT_CATALOG | nvarchar(128) | Unique constraint qualifier. |
| UNIQUE_CONSTRAINT_SCHEMA | nvarchar(128) | Unique constraint owner. |
| UNIQUE_CONSTRAINT_NAME | sysname | Unique constraint. |
| MATCH_OPTION | varchar(7) | Referential constraint-matching conditions. Always returns PARTIAL, which means that a row in the foreign key table columns matches if every value in the foreign key columns is NULL, or every value that is not NULL in the foreign key table columns matches a value in the primary key table columns. |
| UPDATE_RULE | varchar(9) | The action that is taken if a Transact-SQL statement violates referential integrity between tables. Always returns NO ACTION, which means that no action is performed for referential integrity actions and the Transact-SQL statement to perform changes does not execute. |
| DELETE_RULE | varchar(9) | The action that is taken if a Transact-SQL statement violates referential integrity between tables. Always returns NO ACTION, which means that no action is performed for referential integrity actions and the Transact-SQL statement to perform changes does not execute. |
| sysindexes | sysreferences |
| sysobjects |