List of table in Linked Server

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

SELECT * FROM LnkdSrv.DbName.dbo.SysObjects WHERE XType = 'U' ORDER BY Name

Scott Thornburg Hall of Fame Points: 3347 More actions · Answer 2

Noelson,

Check out sp_table_ex in Books Online. It will do exactly what you are trying to accomplish, and works for non-SQL Linked servers as well:

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

Let me know if you need more detail.

Scott Thornburg

sp_tables_ex