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.

Answer 1

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.

Answer 2

Other DBMS that support schemas

• DB2
• H2 Database
• HSQLDB
• Apache Derby
• LucidDB
• Mimer SQL
• Vertica

DBMS that do not support schemas:

• Firebird
• Cubrid
• Teradata (CREATE SCHEMA is a synonym for CREATE DATABASE)