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 vote141 views1 answer
Having all mysql
SQL
1 vote102 views3 answers
How to filter repeated same result using sql query
SQL
0 vote156 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote120 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote116 views1 answer
Sql mod even odd
SQL
0 vote120 views1 answer
Max length found in mysql
SQL
0 vote118 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote107 views1 answer
Sql cross apply vs join
SQL
3 votes110 views1 answer
Show index table
SQL
0 vote129 views1 answer
Linked server delete openquery
SQL