Search for a table name in a database

Search for a table name in a database

## Search for a table

Use this query to search for a table:

       SELECT * FROM INFORMATION_SCHEMA.TABLES 
       WHERE TABLE_NAME LIKE '%%'