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

10 votes137 views4 answers
How to alter table name in mysql
SQL
0 vote147 views1 answer
Multiple tricky query in sql server
SQL
18 votes181 views3 answers
Get the list of all tables in sql server
SQL
10 votes152 views2 answers
SQL rounding numbers
SQL
0 vote144 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote145 views1 answer
Pl sql search saurce code
SQL
2 votes102 views1 answer
Sql float to int
SQL
0 vote139 views2 answers
Csv into data postgres
SQL
11 votes145 views2 answers
Having in sql
SQL
0 vote149 views1 answer
Sqlite3 get data from table c
SQL