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 vote208 views1 answer
Frename oracle
SQL
0 vote191 views1 answer
Database springboot
SQL
1 vote228 views1 answer
What is in condition in sql
SQL
9 votes202 views2 answers
Mysql change value
SQL
2 votes237 views1 answer
Get the mysql table columns data type mysql
SQL
2 votes207 views1 answer
Delete all value query
SQL
3 votes200 views2 answers
How to start mysql in terminal
SQL
15 votes218 views5 answers
Show tables in oracle
SQL
0 vote154 views1 answer
Get last run query sql server
SQL
0 vote219 views1 answer
Can we rollback in sql
SQL