ohad mesika ohad mesika - 3 years ago 255
SQL Question

SQL Server - filtering tables by name with GUI

I have createda Linked Server on server X to be able to query server Y.

there is a possibility to filter the tabels on server Y by name from server X Linked server GUI?

this is how it is look like now, the option "filter" doesn't exists:

enter image description here

Answer Source

Unfortunately SSMS does not provide filtering option at this level. You could use simple SQL query:

SELECT *
FROM [linked_server].[database_name].sys.tables
WHERE [name] LIKE 'table_name'
  AND [schema_id] = SCHEMA_ID('dbo');

There is GUI option though not by using filtering:

View -> Object Explorer Details (F7) and search box

enter image description here

enter image description here

As you can see filter icon is inactive but Search is working.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download