Database Engines and ANSI SQL Compliance

Viewed 16182

I've been searching for half an hour and can't find any resources stating what level of the SQL ANSI standard is supported on various database engines.

It looks like some level of support is provided by most engines, but I'd like to know exactly what level is officially supported.

I'm primarily interested in MySQL, PostgreSQL, SQL Server, and Oracle.

EDIT: PostgreSQL has a great page on compliance, exactly what I was looking for regarding the other engines: http://www.postgresql.org/docs/current/interactive/features.html

5 Answers

According to the HSQLDB manual, it is the most standards compliant RDBMS.

  • Almost all syntactic features of SQL-92 up to Advanced Level are supported
  • SQL:2008 core and many optional features of this standard
Related