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;
- 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;