Are schemas used in other DBMS' than SQL Server?

Question

Since SQL Server 2005, schemas are acting as root namespaces for objects (tables, views, etc).

My question is: are there equivalents in other DBMS'? I'm particularly interested in:

PostgreSQL, Oracle, SQL Server
- Schemas are Supported
MySQL:
- No support for schemas; create schema ... is a synonym for create database ....
SQLite
- No support for schemas; create schema ... causes an error.

Edit: I used OMG Ponies' answer to update above.

score 4 · Accepted Answer · edited May 23 '17 at 10:34

4

Yes, PostgreSQL supports schemas though I don't know when support started. Oracle supports schemas as well.

MySQL does not -- CREATE SCHEMA is an alias for CREATE DATABASE. I don't know about SQLite, but given its limited support I wouldn't think so.

edited May 23 '17 at 10:34

Community

answered Jun 02 '12 at 15:39

OMG Ponies

4

Schemas have been in PostgreSQL since [version 7.3](http://www.postgresql.org/docs/7.3/static/sql-createschema.html), [released on 2002-11-27](http://www.postgresql.org/docs/current/interactive/release-7-3.html). – Erwin Brandstetter Jun 02 '12 at 15:50
1

I'd almost argue that in MySQL there's only one database and `CREATE DATABASE` is a synonym for `CREATE SCHEMA`. – Craig Ringer Jun 03 '12 at 01:57
I second Craig's take on this. – Scott Marlowe Jun 04 '12 at 03:51

score 4 · Answer 2 · 2012-06-02T17:38:11.540

4

Other DBMS that support schemas

DBMS that do not support schemas:

edited Jun 02 '12 at 17:38

answered Jun 02 '12 at 15:57

2 Answers2