Sql find table by name

select table_schema,
       table_name
from information_schema.tables
where table_name like 'payment%'
      and table_schema not in ('information_schema', 'pg_catalog')
      and table_type = 'BASE TABLE'
order by table_name,
         table_schema;

Source: dataedo.com

Similar codes

0 vote158 views1 answer
Mysql date minus 1 day
SQL
0 vote177 views1 answer
Test database for sql
SQL
0 vote179 views1 answer
Sql out file formate
SQL
0 vote173 views1 answer
Show table details postgresql
SQL
8 votes288 views2 answers
Oracle auto increment primary key
SQL
2 votes172 views2 answers
Run mysql command from bash
SQL
18 votes172 views6 answers
Mysql create table
SQL
0 vote154 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote192 views2 answers
Sql query print strings and int
SQL
0 vote174 views2 answers
How to display enum value sql server
SQL