Linked Server Querying

Question

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.

If you know it's SQL Server why did you tag mysql... Please use the correct tags. Also, this information is easily found via google. — Jacob H, Jul 27 '17 at 13:56

Frank · Accepted Answer · 2017-07-27T14:01:22.417

1

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

edited Jul 27 '17 at 14:01

answered Jul 27 '17 at 13:57

Frank

1,901
20
27

I will try.Thanks for that Frank. – Sana Jul 27 '17 at 13:59

score 0 · Answer 2 · answered Jul 27 '17 at 13:58

0

SELECT * FROM (nameoflinkedserver).INFORMATION_SCHEMA.TABLES

answered Jul 27 '17 at 13:58

Ashu

462
3
16

score 0 · Answer 3 · answered Jul 27 '17 at 14:07

0

SELECT * FROM LinkServerName.DatabaseName.SchemaName.TableName

Example

Select * from MYLINKSERVER.MYDATABASE.MYSCHEMA.MYTABLE

answered Jul 27 '17 at 14:07

Arun Vishwakarma

1
3

Linked Server Querying

3 Answers3