SQL Show Schemas Tutorial
This page shows how to view the schemas in a given database.
PostgreSQL, MySQL, and SQL Server
select schema_name from information_schema.schemata;
Oracle
- Schemas are generally synonymous with users in Oracle.
- Thus, viewing schemas in Oracle usually means viewing users.
select
username as schema_name
from
sys.all_users
order by
username;