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

1 vote295 views1 answer
Sql server 2016 reseed identity
SQL
5 votes297 views1 answer
How to check nls format in oracle
SQL
13 votes315 views2 answers
Sql join 3 tables
SQL
0 vote294 views1 answer
C# check if mysql query modified rows
SQL
0 vote296 views1 answer
Ignore case in string sql
SQL
-1 vote289 views1 answer
Sql getdate date only
SQL
0 vote315 views1 answer
Insert set mysql
SQL
11 votes291 views2 answers
Import sql file laravel cmd
SQL
2 votes329 views1 answer
Oracle block
SQL
0 vote288 views1 answer
Mysql command line ubuntu
SQL