external_tables


Columns

Column Type Size Nulls Auto Default Children Parents Comments
name sysname 256 null
object_id int 4 null
principal_id int 4 √ null
schema_id int 4 null
parent_object_id int 4 null
type char 2 √ null
type_desc nvarchar 120 √ null
create_date datetime 16,3 null
modify_date datetime 16,3 null
is_ms_shipped bit 1 null
is_published bit 1 null
is_schema_published bit 1 null
max_column_id_used int 4 √ null
uses_ansi_nulls bit 1 √ null
data_source_id int 4 null
file_format_id int 4 √ null
location nvarchar 8000 √ null
reject_type nvarchar 40 √ null
reject_value float 8 √ null
reject_sample_value float 8 √ null
distribution_type tinyint 1 √ null
distribution_desc nvarchar 240 √ null
sharding_col_id int 4 √ null
remote_schema_name nvarchar 256 √ null
remote_object_name nvarchar 256 √ null
rejected_row_location nvarchar 8000 √ null

Relationships

Close relationships within degrees of separation