reference.RepoObjectSource_FirstResultSet - U

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

RepoObject_guid: 2C90291C-9D61-EB11-84DC-A81E8446D5B0

Description

references on column level

  • source: sys.dm_exec_describe_first_result_set

Examples

Entity Diagram

entity-reference.repoobjectsource_firstresultset

Columns

Table 1. Columns of reference.RepoObjectSource_FirstResultSet - U
PK Column Name Data Type NULL? ID

1

RepoObject_guid

uniqueidentifier

NOT NULL

2

column_ordinal

int

NOT NULL

created_dt

datetime

NOT NULL

is_hidden

bit

NULL

source_column_name

nvarchar(128)

NULL

source_database_name

nvarchar(128)

NULL

source_schema_name

nvarchar(128)

NULL

source_server_name

nvarchar(128)

NULL

source_table_name

nvarchar(128)

NULL

system_type_id

int

NULL

system_type_name

nvarchar(128)

NULL

target_column_name

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobjectsource_firstresultset

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobjectsource_firstresultset

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobjectsource_firstresultset

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobjectsource_firstresultset

Column Reference Diagram

entity_1_1_colref-reference.repoobjectsource_firstresultset

Indexes

PK_RepoObjectSource_FirstResultSet

idx_RepoObjectSource_FirstResultSet__1

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NOT NULL
Referencing Columns

column_ordinal

2

column_ordinal

int

NOT NULL

created_dt

created_dt

datetime

NOT NULL

is_hidden

is_hidden

bit

NULL
Referencing Columns

source_column_name

source_column_name

nvarchar(128)

NULL
Referencing Columns

source_database_name

source_database_name

nvarchar(128)

NULL

source_schema_name

source_schema_name

nvarchar(128)

NULL
Referencing Columns

source_server_name

source_server_name

nvarchar(128)

NULL

source_table_name

source_table_name

nvarchar(128)

NULL
Referencing Columns

system_type_id

system_type_id

int

NULL

system_type_name

system_type_name

nvarchar(128)

NULL

target_column_name

target_column_name

nvarchar(128)

NULL
Referencing Columns