| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.key_constraints (Transact-SQL) |
sys.key_constraints (Transact-SQL) |
rwestMSFT |
randolphwest |
03/15/2017 |
sql |
system-objects |
reference |
|
|
|
|
>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric |
[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricdw-fabric]
Contains a row for each object that is a primary key or unique constraint. Includes sys.objects.type PK and UQ.
| Column name | Data type | Description |
|---|---|---|
| <Columns inherited from sys.objects> | For a list of columns that this view inherits, see sys.objects (Transact-SQL). | |
| unique_index_id | int | ID of the corresponding unique index in the parent object that was created to enforce this constraint. |
| is_system_named | bit | 1 = Name was generated by system. 0 = Name was supplied by the user. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ