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

1 vote140 views1 answer
Timestamp in sqlite
SQL
1 vote127 views1 answer
Sql server 2012 query history
SQL
1 vote130 views4 answers
Sequelize migration default value
SQL
12 votes143 views4 answers
Mysql version
SQL
0 vote144 views1 answer
Postgresql in vs any performance
SQL
0 vote135 views1 answer
Top frequency in sql server
SQL
2 votes135 views1 answer
Plsql left() function
SQL
3 votes137 views1 answer
Two select sql
SQL
0 vote196 views1 answer
Mysql readable output
SQL
0 vote136 views1 answer
How many columns can be used for creating index?
SQL