Table: dbo.unique_constraints (Unique keys)

Schema dbo
Name unique_constraints
Title Unique keys
Module Schema and Metadata

Holds table unique keys, either defined in DBMS or by user in Dataedo. The two types are distinguished by source column (DBMS/USER).

Columns
PK Name Data type Null Attributes Description
1 unique_constraint_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 table_id int Table to which unique key belongs.
Table to which unique key belongs.
3 source nvarchar(50) Default: 'USER' 'DBMS' for imported from DBMS, 'USER' for defined by user in repository only.
'DBMS' for imported from DBMS, 'USER' for defined by user in repository only.
Default: 'USER'
4 name nvarchar(250) Unique constraint name from DBMS or assigned by user if constraint is user defined.
Unique constraint name from DBMS or assigned by user if constraint is user defined.
5 description nvarchar(MAX) Unique key description defined with Dataedo.
Unique key description defined with Dataedo.
6 primary_key bit 1 when key is primary key, 0 when regular unique key
1 when key is primary key, 0 when regular unique key
7 status char(1) Default: 'A' 'D' if unique key was deleted from DBMS, 'A' otherwise
'D' if unique key was deleted from DBMS, 'A' otherwise
Default: 'A'
8 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
9 created_by nvarchar(100) Default: user_name() Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: user_name()
10 last_modification_date datetime Default: getdate() Stanadard row last update timestamp.
Stanadard row last update timestamp.
Default: getdate()
11 modified_by nvarchar(100) Default: user_name() Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: user_name()
12 disabled bit 1 when imported key is disabled (only DBMS)
1 when imported key is disabled (only DBMS)
Relations
Foreign table Primary table Join Title / Name / Description
dbo.unique_constraints dbo.tables dbo.unique_constraints.table_id = dbo.tables.table_id FK_unique_constraints_tables
dbo.unique_constraints.table_id = dbo.tables.table_id
FK_unique_constraints_tables
dbo.unique_constraints_columns dbo.unique_constraints dbo.unique_constraints_columns.unique_constraint_id = dbo.unique_constraints.unique_constraint_id FK_unique_constraints_columns_unique_constraints
dbo.unique_constraints_columns.unique_constraint_id = dbo.unique_constraints.unique_constraint_id
FK_unique_constraints_columns_unique_constraints
Unique keys
Key name Columns Description
PK_unique_constraints unique_constraint_id Table primary key.
Table primary key.
Triggers
Key name When Description
trg_unique_constraints_Modify After Insert, Update Standard insert/update trigger setting last_modification_date, modified by columns
Standard insert/update trigger setting last_modification_date, modified by columns
Uses
Name
dbo.unique_constraints (Unique keys)
Used by
Name
dbo.unique_constraints (Unique keys)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30