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 vote84 views1 answer
Mysql convert column to uppercase
SQL
0 vote115 views2 answers
Influxdb delete measurement based on date
SQL
1 vote123 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
11 votes154 views4 answers
Reset identity column values in sql server
SQL
11 votes253 views2 answers
Import mysql dump command line windows
SQL
4 votes135 views2 answers
Oracle last day of month
SQL
0 vote128 views1 answer
How to make case insensitive in sql
SQL
4 votes134 views1 answer
Find tables with column name in sql
SQL
0 vote135 views1 answer
Sql server remove 0 from left
SQL
0 vote141 views1 answer
Mysql url data type
SQL