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 DATE, TIME, and TIMESTAMP data types.

Examples: The following embedded SQL statement returns the SQL Dialect:

EXEC SQL
SHOW SQL DIALECT;

See Also

Advance To: