Table: dbo.columns (Columns)

Schema dbo
Name columns
Title Columns
Module Schema and Metadata

Holds tables' and views' columns.

Columns
PK Name Data type Null Attributes Description
1 column_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 table_id int Table to which column belongs.
Table to which column belongs.
3 ordinal_position int Position of column in table.
Position of column in table.
4 name nvarchar(250) Column name in DBMS.
Column name in DBMS.
5 title nvarchar(250) Column alternative title.
Column alternative title.
6 description nvarchar(MAX) Column description in Dataedo. Description is imported from database at first import and during schema update, but only if it was empty.
Column description in Dataedo. Description is imported from database at first import and during schema update, but only if it was empty.
7 datatype nvarchar(250) Column data type.
Column data type.
8 data_length nvarchar(50) Data length/precision as text. Depending on data type it can have differenent formats, e.g. "100", "5,4", "MAX" etc. Null if column has no length/precision defined.
Data length/precision as text. Depending on data type it can have differenent formats, e.g. "100", "5,4", "MAX" etc. Null if column has no length/precision defined.
9 primary_key char(1) Default: 0 1 if column is part of primary key, 0 otherwise
1 if column is part of primary key, 0 otherwise
Default: 0
10 nullable bit Default: 1 1 if column is nullable, 0 otherwise
1 if column is nullable, 0 otherwise
Default: 1
11 default_def nvarchar(4000) Default value definition.
Default value definition.
12 identity_def nvarchar(50) Identity definition (e.g. "1, 1"). SQL Server only.
Identity definition (e.g. "1, 1"). SQL Server only.
13 status char(1) Default: 'A' 'D' if column was deleted in DBMS, 'A' otherwise. Deleted columns aren't exported to documentation.
'D' if column was deleted in DBMS, 'A' otherwise. Deleted columns aren't exported to documentation.
Default: 'A'
14 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
15 created_by nvarchar(100) Default: NULL Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: NULL
16 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
17 modified_by nvarchar(100) Default: NULL Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: NULL
18 default_value nvarchar(MAX) Formula of column defalut value. NULL if field has not default value specification.
Formula of column defalut value. NULL if field has not default value specification.
19 is_identity bit Default: 0 Is column an identity/auto incremented column. 1 - identity/auto increment, 0 - otherwise.
Is column an identity/auto incremented column. 1 - identity/auto increment, 0 - otherwise.
Default: 0
20 is_computed bit Default: 0 Is column a computed column. 1 - computed column, 0 - regular column. If column is computed, you should expect that calculation formula is imported to computed_formula field
Is column a computed column. 1 - computed column, 0 - regular column. If column is computed, you should expect that calculation formula is imported to computed_formula field
Default: 0
21 computed_formula nvarchar(MAX) Calculation formula for computed columns. NULL for regular fields.
Calculation formula for computed columns. NULL for regular fields.
Relations
Foreign table Primary table Join Title / Name / Description
dbo.columns dbo.tables dbo.columns.table_id = dbo.tables.table_id FK_column_table
dbo.columns.table_id = dbo.tables.table_id
FK_column_table
dbo.erd_nodes_columns dbo.columns dbo.erd_nodes_columns.column_id = dbo.columns.column_id FK_erd_nodes_columns_columns
dbo.erd_nodes_columns.column_id = dbo.columns.column_id
FK_erd_nodes_columns_columns
dbo.tables_relations_columns dbo.columns dbo.tables_relations_columns.column_fk_id = dbo.columns.column_id FK_tables_relations_columns_column_fk
dbo.tables_relations_columns.column_fk_id = dbo.columns.column_id
FK_tables_relations_columns_column_fk
dbo.tables_relations_columns dbo.columns dbo.tables_relations_columns.column_pk_id = dbo.columns.column_id FK_tables_relations_columns_column_pk
dbo.tables_relations_columns.column_pk_id = dbo.columns.column_id
FK_tables_relations_columns_column_pk
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
Unique keys
Key name Columns Description
PK_columns column_id Table primary key.
Table primary key.
Triggers
Key name When Description
trg_columns_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.columns (Columns)
Used by
Name
dbo.columns (Columns)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30