columns


Columns

Column Type Size Nulls Auto Default Children Parents Comments
object_id int 4 null
name sysname 256 √ null
column_id int 4 null
system_type_id tinyint 1 null
user_type_id int 4 null
max_length smallint 2 null
precision tinyint 1 null
scale tinyint 1 null
collation_name sysname 256 √ null
is_nullable bit 1 √ null
is_ansi_padded bit 1 null
is_rowguidcol bit 1 null
is_identity bit 1 null
is_computed bit 1 null
is_filestream bit 1 null
is_replicated bit 1 √ null
is_non_sql_subscribed bit 1 √ null
is_merge_published bit 1 √ null
is_dts_replicated bit 1 √ null
is_xml_document bit 1 null
xml_collection_id int 4 null
default_object_id int 4 null
rule_object_id int 4 null
is_sparse bit 1 √ null
is_column_set bit 1 √ null
generated_always_type tinyint 1 √ null
generated_always_type_desc nvarchar 120 √ null
encryption_type int 4 √ null
encryption_type_desc nvarchar 128 √ null
encryption_algorithm_name sysname 256 √ null
column_encryption_key_id int 4 √ null
column_encryption_key_database_name sysname 256 √ null
is_hidden bit 1 √ null
is_masked bit 1 null
graph_type int 4 √ null
graph_type_desc nvarchar 120 √ null

Relationships

Close relationships within degrees of separation