Page History
...
Contents
Table of 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
- 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.
...
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