System Stored Procedure
EXEC sp_tables_ex
@table_server = 'your_linked_server_name',
@table_catalog = 'your_database',
@table_type = 'TABLE'
EXEC sp_tables_ex
@table_server = 'your_linked_server_name',
@table_catalog = 'your_database',
@table_type = 'VIEW'
No comments: