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

50 votes358 views6 answers
Sql duplicate rows
SQL
0 vote262 views1 answer
How to check replication lag in mySQL
SQL
0 vote315 views2 answers
Amazon linux postgresql client
SQL
4 votes289 views2 answers
Postgre sql create table
SQL
25 votes291 views6 answers
Sql update query
SQL
0 vote277 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote276 views1 answer
Mysql command line ubuntu
SQL
0 vote291 views1 answer
Ubuntu connect to mssql database
SQL
103 votes470 views2 answers
Sql server LIKE '%%'
SQL
2 votes288 views6 answers
In operator in sql
SQL