sql server filter table name

https://stackoverflow.com/questions/26577464/how-to-find-a-table-in-sql-server-if-only-the-partial-table-name-is-known

Using SSMS Object Explorer, right-click on the Tables node and select Filter-->Filter Settings. The list will be filtered accordingly.

Alternatively, you can query the catalog or INFORMATION_SCHEMA views:

SELECT 
      OBJECT_SCHEMA_NAME(object_id) AS schema_name
    , name
FROM sys.tables
WHERE name LIKE '%[_]13[_]6[_]14%';

SELECT 
      TABLE_SCHEMA
    , TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE '%[_]13[_]6[_]14%';

 

 

作者:Chuck Lu    GitHub