SHOW SQL DIALECT
From InterBase
Go Up to Statement and Function Reference (Language Reference Guide)
Returns the current client SQL Dialect setting and the database SQL Dialect value. Available in gpre
and isql
.
SHOW SQL DIALECT;
Description: SHOW SQL DIALECT
returns the current client SQL Dialect setting and the database SQL Dialect value, either 1, 2, or 3.
SQL Dialect | Used for |
---|---|
1 |
InterBase 5 and earlier compatibility |
2 |
Transitional dialect used to flag changes when migrating from dialect 1 to dialect 3. |
3 |
Current InterBase; allows you to use delimited identifiers, exact numerics, and |
Examples: The following embedded SQL statement returns the SQL Dialect:
EXEC SQL
SHOW SQL DIALECT;