Teradata Database conforms closely to the ANSI/ISO SQL standard while supporting extensions that enable users to take full advantage of the efficiency benefits of parallelism. Teradata develops new features that conform to existing ANSI/ISO standards and handles differences between Teradata SQL and ANSI/ISO SQL as follows:
| WHEN ... | THEN ... |
|---|---|
| the difference between the Teradata SQL dialect and the ANSI/ISO SQL standard for a language feature is slight | the ANSI/ISO SQL is added to Teradata Database feature as an option. |
| the difference between the Teradata SQL dialect and the ANSI/ISO SQL standard for a language feature is significant | both syntaxes are offered and the user has the choice of operating in either Teradata or ANSI mode or of turning off SQL Flagger. The mode can be defined:
|