What is the System Procedure to List out Table from Linked Server?

Question

Sushant Mishra · Answer

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
and and EXEC sp_tables_ex@table_serverand and and and and and and and ='your_linked_server_name', @table_catalogand  and  and ='Sample', @table_typeand and and and and and and and = 'SignIn'
You have to give database name in table catalog and table name or view name in table type
and

interview

What is the System Procedure to List out Table from Linked Server?

Sushant Mishra

Can you answer this question?

1 Answers

Liked By