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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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)
- 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)
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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)
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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.
Explain Format: Displays the Date and Time Format Characters