Search code examples
sql-servert-sqllinked-server

Linked Server Querying

I have the table name which is in the linked server.How to write a T-SQL query to find the database name (In linked server) from that table name? I have no idea about linked server querying.Kindly help me
Thank you.

Solution 
  • SELECT * FROM <linkedservername>.INFORMATION_SCHEMA.TABLES

    or

    SELECT * FROM <linkedservername>.INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'XXXXX'

    or

    select * from <linkedservername>.master.sys.databases

    for get a list of all Databases