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

3 votes251 views4 answers
Ubuntu stop mysql
SQL
0 vote220 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote179 views2 answers
Jupyter notebook connect to database
SQL
-2 votes222 views1 answer
Create trigger syntax
SQL
0 vote255 views1 answer
Add timestamp column to existing table t-sql
SQL
2 votes228 views1 answer
How to make multiple keys as primary in bdms
SQL
5 votes253 views4 answers
SQL Order of execution
SQL
0 vote225 views1 answer
Run mssql server terminal
SQL
1 vote232 views2 answers
Mysql insert generate serie
SQL
0 vote215 views1 answer
How many columns can be used for creating index?
SQL