Sushant Mishra Total Post:37 Points:185 Posted by Sushant Mishra September-18-2017 4:08 AM SQL Server SQL Server 2008 SQL Server 2012 Database 1 Answer(s) 178 View(s) Ratings: Rate this:
Sushant Mishra Post:37 Points:185 What is the System Procedure to List out Table from Linked Server? Posted on 7 months ago It return the list of table from the database you can also use it for view you have to pass view name in table type EXEC sp_tables_ex@table_server ='your_linked_server_name', @table_catalog ='Sample', @table_type = 'SignIn' You have to give database name in table catalog and table name or view name in table type
Post:37
Points:185What is the System Procedure to List out Table from Linked Server?
It return the list of table from the database you can also use it for view you have to pass view name in table type
You have to give database name in table catalog and table name or view name in
table type