Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » Alphabetical list of functions


SQLDIALECT function [Miscellaneous]

Returns either Watcom-SQL or Transact-SQL, to indicate the SQL dialect of a statement.

SQLDIALECT( sql-statement-string )
  • sql-statement-string   The SQL statement that the function uses to determine its dialect.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.


The following statement returns the string Transact-SQL.

   SQLDIALECT( 'SELECT EmployeeName = Surname FROM Employees' )
FROM dummy;