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 vote186 views1 answer
How to print out column name differently in mysql
SQL
0 vote213 views1 answer
Oracle string length
SQL
0 vote227 views1 answer
Show tables in cassandra cql
SQL
1 vote151 views2 answers
Last working day in week date function in sql
SQL
0 vote198 views1 answer
Add timestamp column to existing table t-sql
SQL
8 votes189 views1 answer
Today minus 15 days postgresql
SQL
1 vote181 views5 answers
Spring boot sql logging
SQL
0 vote207 views1 answer
How to display value of variable in mysql
SQL
6 votes297 views2 answers
Database url postgres
SQL
1 vote199 views1 answer
Sql week commencing date
SQL