Monday, October 18, 2010

List Tables From Linked Server

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: