sys.sp_data_source_objects

Description

Returns list of table objects that are available to be virtualized.

Syntax

sys.sp_data_source_objects
[ @data_source = ]
N
'data_source'
[ , [ @object_root_name = ]
N
'object_root_name'
]
[ , [ @max_search_depth = ] max_search_depth ]
[ , [ @search_options = ]
N
'search_options'
]
[ ; ]

Examples

Example 1

DATABASE
"database"
database
NULL
SCHEMA
"database"."dbo"
dbo
NULL
TABLE
"database"."dbo"."customer"
customer
[database].[dbo].[customer]
TABLE
"database"."dbo"."item"
item
[database].[dbo].[item]
TABLE
"database"."dbo"."nation"
nation
[database].[dbo].[nation]

Example 2

DECLARE
@data_source
AS
SYSNAME = N
'ExternalDataSourceName'
;
DECLARE
@object_root_name
AS
NVARCHAR (
MAX
) =
NULL
;
DECLARE
@max_search_depth
AS
INT
= 3;
EXECUTE sp_data_source_objects
@data_source,
@object_root_name,
@max_search_depth;

Example 3

DECLARE
@data_source
AS
SYSNAME = N
'ExternalDataSourceName'
;
DECLARE
@object_root_name
AS
NVARCHAR (
MAX
) =
NULL
;
EXECUTE sp_data_source_objects
@data_source,
@object_root_name;