Menu
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
594
When you use the LOG MODE ANSI option in the CREATE DATABASE statement, the database that you create is an ANSI-compliant database that conforms to the ANSI/ISO standard for the SQL language.
"ANSI SQL" is a series of standards for modeling and manipulating data. "SQL" is whatever bits of ANSI SQL a SQL engine vendor chooses to implement, plus whatever else they want to add.
Industry-accepted committees are the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO), which is affiliated with the International Electrotechnical Commission (IEC). Both ANSI and the ISO/IEC have accepted SQL as the standard language for relational databases.
Since Oracle 9i, Oracle SQL supports the ANSI SQL syntax.
these might help a little:
Comparison of different SQL implementations
wikipedia - Comparison of relational database management systems
wikipedia - SQL - Standardization
104
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
