Table: dbo.unique_constraints_columns (Uniquie keys' columns)

Schema dbo
Name unique_constraints_columns
Title Uniquie keys' columns
Module Schema and Metadata

Stores unique key columns.

Columns
PK Name Data type Null Attributes Description
1 unique_constraint_column_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 unique_constraint_id int Ref: unique key.
Ref: unique key.
3 column_id int Ref: table/view column.
Ref: table/view column.
4 ordinal_position int Column position in index/constraint.
Column position in index/constraint.
5 status char(1) Default: 'A' 'D' if unique key column was deleted from DBMS, 'A' otherwise
'D' if unique key column was deleted from DBMS, 'A' otherwise
Default: 'A'
6 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
7 created_by nvarchar(100) Default: user_name() Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: user_name()
8 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
9 modified_by nvarchar(100) Default: user_name() Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: user_name()
Relations
Foreign table Primary table Join Title / Name / Description
dbo.unique_constraints_columns dbo.columns dbo.unique_constraints_columns.column_id = dbo.columns.column_id FK_unique_constraints_columns_columns
dbo.unique_constraints_columns.column_id = dbo.columns.column_id
FK_unique_constraints_columns_columns
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_columns unique_constraint_column_id Table primary key
Table primary key
Triggers
Key name When Description
trg_unique_constraints_cols_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_columns (Uniquie keys' columns)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30