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 vote246 views2 answers
Alter table add multiple columns mysql
SQL
8 votes253 views3 answers
Connect python to mysql
SQL
0 vote218 views1 answer
Mysql regex exact match
SQL
0 vote218 views1 answer
Strat with in sql
SQL
0 vote261 views1 answer
Carbon mysql d m y to y-m-d
SQL
1 vote234 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote238 views1 answer
Java check if something is in mysql table
SQL
6 votes630 views3 answers
Sql select last id
SQL
1 vote225 views1 answer
SQL server query column yes or no
SQL
0 vote288 views1 answer
Osm2pgsql mac
SQL