sys.sp_tables_ex

Description

Returns table information about the tables from the specified linked server.

Syntax

sp_tables_ex
[ @table_server = ]
N
'table_server'
[ , [ @table_name = ]
N
'table_name'
]
[ , [ @table_schema = ]
N
'table_schema'
]
[ , [ @table_catalog = ]
N
'table_catalog'
]
[ , [ @table_type = ]
N
'table_type'
]
[ , [ @f
U se
P attern = ] f
U se
P attern ]
[ ; ]