Versions Compared

Old Version 4

changes.mady.by.user Nadine Hinojosa

Saved on

compared with

New Version Current

changes.mady.by.user Nadine Hinojosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Contents

Table of Contents
minLevel2

Scripts

Amazon Athena

Amazon Athena Scripts.pngImage RemovedImage 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

Amazon Redshift.pngImage RemovedImage 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

Apache Cassandra.pngImage Removed


  • 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

Apache Derby.pngImage RemovedImage 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

Apache Hive.pngImage RemovedImage 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

DB2 LUW 7.pngImage RemovedImage 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

DB2 LUW 8.pngImage RemovedImage 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

DB2 iSeries.pngImage RemovedImage 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

DB2 z-OS.pngImage RemovedImage 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

Generic JDBC.pngImage RemovedImage 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

GoogleBigQuery.pngImage RemovedImage 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

Greenplum.pngImage RemovedImage 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

Informix.pngImage RemovedImage 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

MS Excel.pngImage RemovedImage 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)

MS SQL Database (Azure).pngImage RemovedImage 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)

MS SQL Database Azure Synapse Scripts.pngImage RemovedImage 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

SQL Server.pngImage RemovedImage 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

MS SQL Server 7.pngImage RemovedImage 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

MariaDB 10..pngImage RemovedImage 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

MongoDB.pngImage RemovedImage 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

MySQL.pngImage RemovedImage 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

Netezza.pngImage RemovedImage 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

Oracle 8i.pngImage RemovedImage 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

Oracle 9i.pngImage RemovedImage 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

ParAccel Analytic Platform.pngImage RemovedImage 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

PostgreSQL.pngImage RemovedImage 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

SAP HANA.pngImage RemovedImage 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)

SingleStore Scripts.pngImage RemovedImage 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

Snowflake Scripts.pngImage RemovedImage 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

SQLite.pngImage RemovedImage 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

Sybase ASE.pngImage RemovedImage 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

Sybase Anywhere.pngImage RemovedImage 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

Sybase IQ.pngImage RemovedImage 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

Teradata Aster Database.pngImage RemovedImage 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

Teradata Database.pngImage RemovedImage 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

Vertica.pngImage RemovedImage 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

VoltDB.pngImage RemovedImage 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.
     

...

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

Results Format.pngImage RemovedImage Added

Explain Format: Displays the Date and Time Format Characters

Results Time Date Format.pngImage RemovedImage Added