repo.RepoObjectColumn - U

type: U ( user table ), modify_date: 2022-09-05 18:17:59

RepoObject_guid: 3E90291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.repoobjectcolumn

Columns

Table 1. Columns of repo.RepoObjectColumn - U
PK Column Name Data Type NULL? ID

1

Default: DF_RepoObjectColumn_RepoObjectColumn_guid
(newsequentialid())

uniqueidentifier

NOT NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

tinyint

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

uniqueidentifier

NULL

int

NULL

nvarchar(max)

NULL

bit

NULL

nvarchar(128)

NULL

nvarchar(max)

NULL

Default: DF_RepoObjectColumn_Repo_generated_always_type
((0))

tinyint

NOT NULL

int

NULL

sql_variant

NULL

Default: DF_RepoObjectColumn_Repo_is_computed
((0))

bit

NOT NULL

Default: DF_RepoObjectColumn_Repo_is_identity
((0))

bit

NOT NULL

bit

NULL

bit

NULL

sql_variant

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

bit

NULL

uniqueidentifier

NOT NULL

int

NULL

Default: DF_RepoObjectColumn_RepoObjectColumn_name
(newid())

nvarchar(128)

NOT NULL

int

NULL

Default: DF_RepoObjectColumn_SysObjectColumn_name
(newid())

nvarchar(128)

NOT NULL

Definition (PERSISTED)
(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then [RepoObjectColumn_name] else [SysObjectColumn_name] end)

nvarchar(128)

NOT NULL

Definition
(CONVERT([bit],case when [RepoObjectColumn_name]<>[SysObjectColumn_name] then (1) else (0) end,(0)))

bit

NULL

Definition (PERSISTED)
(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)

int

NOT NULL

Definition (PERSISTED)
(case when TRY_CAST([SysObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)

int

NOT NULL

Foreign Key Diagram

entity_1_1_fk-repo.repoobjectcolumn

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.repoobjectcolumn

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.repoobjectcolumn

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.repoobjectcolumn

Column Reference Diagram

entity_1_1_colref-repo.repoobjectcolumn

Indexes

PK_RepoObjectColumn

UK_RepoObjectColumn__RepoNames

UK_RepoObjectColumn__SysNames

idx_RepoObjectColumn__1

Column Details

_

RepoObjectColumn_guid

1

RepoObjectColumn_guid

Default: DF_RepoObjectColumn_RepoObjectColumn_guid
(newsequentialid())

uniqueidentifier

NOT NULL

Referencing Columns

RepoObjectColumn_name

RepoObjectColumn_name

Default: DF_RepoObjectColumn_RepoObjectColumn_name
(newid())

nvarchar(128)

NOT NULL

Column_name

Column_name

Definition (PERSISTED)
(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then [RepoObjectColumn_name] else [SysObjectColumn_name] end)

nvarchar(128)

NOT NULL

Description

(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then [RepoObjectColumn_name] else [SysObjectColumn_name] end)


has_different_sys_names

has_different_sys_names

Definition
(CONVERT([bit],case when [RepoObjectColumn_name]<>[SysObjectColumn_name] then (1) else (0) end,(0)))

bit

NULL

Description

(CONVERT([bit],case when [RepoObjectColumn_name]<>[SysObjectColumn_name] then (1) else (0) end))


is_RepoObjectColumn_name_uniqueidentifier

is_RepoObjectColumn_name_uniqueidentifier

Definition (PERSISTED)
(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)

int

NOT NULL

Description

(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)


is_SysObjectColumn_name_uniqueidentifier

is_SysObjectColumn_name_uniqueidentifier

Definition (PERSISTED)
(case when TRY_CAST([SysObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)

int

NOT NULL

Description

(case when TRY_CAST([SysObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)