Aqua Data Studio supports Client Side and Server Side Comments.
Client-side comments are comments which ADS removes from a SQL statement before executing or sending them to the server database. Server-side comments are executed (sent) to the server with a SQL statement. The reason for server-side comments is to support comments stored in Stores Procedures.
When creating Stored Procedures that include comments, Aqua Data Studio needs to include the comments in the SQL statement that is executed on the server.
Types of comments ADS supports:
1: Block Comment -> /* Block Comment */
2: Line Comment -> -- Line Comment
3: Line Comment -> // Line Comment
ADS comments are configurable
Different databases support different types of comments. By using the Options dialog box, a user may select each type of comment to be a client or a server-side comment per database. You can confirm what statement and comments will be executed on the server with an "Execute Parse" on a statement/script before executing.
Below is a list of databases, the comment types they support, and the default value for each database.
The comments option each database vendor has are available by File > Options > Scripts
BBSSC: Block Server Side Comment
SSSSC: Slash Slash Server Side Comment
DDSSC: Dash Dash Server Side Comment
Amazon Redshift | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | FALSE |
Apache Cassandra | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | FALSE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | FALSE | FALSE |
Apache Derby | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | FALSE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
Apache Hive | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | FALSE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | FALSE |
DB2 - LUW 7.x | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | FALSE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
DB2 - LUW 8.x/9.x/10.x | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | FALSE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
DB2 - iSeries | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | FALSE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
DB2 - z/OS | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
Generic JDBC/ODBC | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | FALSE |
SSSSC: { // }: | TRUE | FALSE |
DDSSC: { -- }: | TRUE | FALSE |
Google BigQuery | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | SELECT: TRUE DML/DDL: FALSE | TRUE |
SSSSC: { // }: | SELECT: TRUE DML/DDL: FALSE | TRUE |
DDSSC: { -- }: | SELECT: TRUE DML/DDL: FALSE | TRUE |
Greenplum | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | FALSE |
Informix | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
MS Excel | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | FALSE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | FALSE | FALSE |
MS SQL Database (Azure) | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
MS SQL Server | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
MS SQL Server 7.0 | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
MariaDB | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | FALSE |
MongoDB | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | FALSE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | FALSE | FALSE |
MySQL | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | FALSE |
Netezza | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | FALSE |
Oracle 8i | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
Oracle 9i/10g/11g/12c | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
ParAccel Analytic Platform | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | FALSE |
PostgreSQL | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
SAP HANA | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
SQLite | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
Sybase ASE 11/12/15/16 | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | TRUE |
Sybase Anywhere | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | TRUE | TRUE |
DDSSC: { -- }: | TRUE | TRUE |
Sybase IQ | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | TRUE | TRUE |
DDSSC: { -- }: | TRUE | TRUE |
Teradata Aster Database | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | FALSE |
Teradata Database | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | FALSE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | FALSE |
Vertica | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | TRUE |
SSSSC: { // }: | FALSE | FALSE |
DDSSC: { -- }: | TRUE | FALSE |
VoltDB | DB SUPPORT | ADS DEFAULT |
BBSSC { /* */ }: | TRUE | FALSE |
SSSSC: { // }: | TRUE | FALSE |
DDSSC: { -- }: | TRUE | FALSE |