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

2 votes95 views4 answers
Mysql select into new table
SQL
17 votes114 views3 answers
Postgresql list users
SQL
0 vote103 views1 answer
Select all columns except one sql
SQL
0 vote104 views1 answer
Create table sql generator
SQL
2 votes100 views2 answers
Oracle no data found error code
SQL
0 vote98 views1 answer
Tsql default value when no value returned by query
SQL
0 vote104 views1 answer
Oracle allow space to user
SQL
11 votes110 views4 answers
Update row in mysql
SQL
1 vote109 views1 answer
Python clean sql string
SQL
0 vote110 views1 answer
Sql query for displaying age from oldest to youngest
SQL