# Search for a table name in a database

> Search for a table Use this query to search for a table:

- Canonical: https://preview.arshadmehmood.com/today-i-learned/sql/search-for-table-name-in-a-database/
- Section: sql
- Author: Arshad Mehmood

## Search for a table
    
   Use this query to search for a table:
    
   ```sql
       SELECT * FROM INFORMATION_SCHEMA.TABLES 
       WHERE TABLE_NAME LIKE '%%'
   ```