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 vote413 views1 answer
Redirection 301 htaccess nom de domaine
SQL
1 vote227 views1 answer
Mysql select and count left join
SQL
1 vote235 views1 answer
Homebrew install mysql
SQL
18 votes202 views6 answers
Mysql create table
SQL
1 vote209 views1 answer
Snowflake rename column name
SQL
1 vote194 views1 answer
Partition by sql server
SQL
3 votes205 views1 answer
Oracle undo tablespace list by user
SQL
7 votes240 views1 answer
Xampp reset mysql
SQL
1 vote209 views1 answer
Mysql dump specific tables
SQL
0 vote235 views1 answer
SQL-Arten
SQL