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 vote184 views1 answer
Sqldf change user
SQL
1 vote179 views1 answer
Deleting database in sql
SQL
2 votes206 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote204 views1 answer
Full outer join in mariadb mysql
SQL
104 votes1.1K views2 answers
Like in mysql
SQL
1 vote198 views1 answer
Sql select where id not exists in another table
SQL
0 vote359 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote202 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote223 views1 answer
Mysql backup query
SQL
0 vote235 views2 answers
Search stored procedures
SQL