sys.sp_data_source_table_columns

Description

Returns a list of columns in external data source table.

Syntax

sys.sp_data_source_table_columns
[ @data_source = ]
N
'data_source'
, [ @table_location = ]
N
'table_location'
[ , [ @column_name = ]
N
'column_name'
]
[ , [ @search_options = ]
N
'search_options'
]
[ ; ]

Examples

Example 1

sp_data_source_table_columns

Example 2

sp_data_source_table_columns

Example 3

server

Example 4

schema

Example 5

DECLARE
@data_source
AS
SYSNAME = N
'ExternalDataSourceName'
;
DECLARE
@table_location
AS
NVARCHAR (400) = N
'[database].[schema].[table]'
;
EXECUTE sp_data_source_table_columns
@data_source,
@table_location;