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 vote312 views1 answer
Mysql trim characters
SQL
0 vote323 views1 answer
Mysql beautifier terminla
SQL
0 vote376 views1 answer
Sql server phone constraint
SQL
21 votes359 views6 answers
Update sql
SQL
0 vote325 views1 answer
Populate db from command line postgres
SQL
0 vote367 views1 answer
"Hello User Name"
SQL
12 votes366 views6 answers
Distinct in sql server
SQL
0 vote353 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote342 views1 answer
Insert set mysql
SQL
0 vote331 views1 answer
Delete data from database sqlite android
SQL