Page History

Scripts and Results Options determine settings for scripts (including server side comments, quote identifier and statement separator settings) and Query Results display settings (including data type formatting).

Contents

• Scripts
  • Amazon Athena
  • Amazon Redshift
  • Apache Cassandra
  • Apache Derby
  • Apache Hive
  • DB2 - LUW 7.x
  • DB2 - LUW 8.x/9.x/10.x
  • DB2 - iSeries
  • DB2 - z/OS
  • Generic - JDBC/ODBC
  • Google BigQuery
  • Greenplum
  • Informix
  • MS Excel
  • MS SQL Database (Azure)
  • MS SQL Database (Azure Synapse)
  • MS SQL Server
  • MS SQL Server 7.0
  • MariaDB
  • MongoDB
  • MySQL
  • Netezza
  • Oracle 8i
  • Oracle 9i/10g/11g/12c
  • ParAccel Analytic Platform
  • PostgreSQL
  • SAP HANA
  • SingleStore (MemSQL)
  • Snowflake
  • SQLite
  • Sybase ASE 11/12/15/16
  • Sybase Anywhere
  • Sybase IQ
  • Teradata Aster Database
  • Teradata Database
  • Vertica
  • VoltDB
• Results Format Options

Scripts

Amazon Athena

Image Added

• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.
• Include Databases for Table Completion: Enable qualifying with database name when completing a table completion on all databases.

Amazon Redshift

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

Apache Cassandra

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Keyspace: Enable the qualifying of object name with keyspace name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

Apache Derby

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields

Apache Hive

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields

DB2 - LUW 7.x

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

DB2 - LUW 8.x/9.x/10.x

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

DB2 - iSeries

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ;' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

DB2 - z/OS

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields

Generic - JDBC/ODBC

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields

Google BigQuery

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields

Greenplum

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields

Informix

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

MS Excel

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

MS SQL Database (Azure)

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

MS SQL Database (Azure Synapse)

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.
• Include Schema For Table Completion: Enable qualifying with schema name when completing a table completion.

MS SQL Server

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.
• Include Schema For Table Completion: Enable qualifying with schema name when completing a table completion.

MS SQL Server 7.0

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields

MariaDB

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

MongoDB

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

MySQL, Aurora MySQL, Google MySQL

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

Netezza

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

Oracle 8i

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

Oracle 9i/10g/11g/12c

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

ParAccel Analytic Platform

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

PostgreSQL, Aurora PostgreSQL, Google PostgreSQL

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

SAP HANA

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

SingleStore (MemSQL)

Image Added

• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

Snowflake

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

SQLite

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

Sybase ASE 11/12/15/16

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

Sybase Anywhere

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

Sybase IQ

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

Teradata Aster Database

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

Teradata Database

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

Vertica

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.

VoltDB

Image Added

• Server Side Comment: /* */: Enable Server Side Comments for block comments.
• Server Side Comment: //: Enable Server Side Comments for slash comments.
• Server Side Comment: --: Enable Server Side Comments for dash comments
• Quote Identifier: Specifies the quote identifier for objects.
• Qualify Object w/ Schema: Enable the qualifying of object name with schema name.
• Visual Editing Quote Identifier: Enable the quote identifiers in Visual Editing.
• Quote Identifier for Table Completion: Identifies the quote identifier to use when completing a table completion.
• Quote Identifier for Column Completion: Identifies the quote identifier to use when completing a column completion.
• Statement Separator: Statement separator to use when generating DDL scripts
• ';' Statement Separator: In SQL Scripts, interpret ';' at end of line as statement separator. NOTE: Enabling this feature man cause issues with PL/SQL, Transact-SQL and Procedure DDL statements
• Case for Auto Completion: Case conversion for auto completion of columns and fields.
   

Results Format Options

The Results Format options allow you to define how datatypes are formatted in the Text and Grid results.

Image Added

Explain Format: Displays the Date and Time Format Characters

Image Added