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

6 votes209 views2 answers
Drop foreign key
SQL
1 vote261 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
1 vote206 views1 answer
Mysql last year
SQL
0 vote184 views1 answer
Count the table indatabase
SQL
0 vote233 views1 answer
Set root password mysql xampp
SQL
41 votes301 views6 answers
Alter table add column in SQL Server
SQL
0 vote251 views1 answer
Import sql inside hide sql
SQL
0 vote207 views1 answer
Setval in postgres
SQL
0 vote205 views1 answer
We are intrested to work with your organization
SQL
0 vote201 views2 answers
Plsql regex match whole word
SQL