Returns the DatabaseType.
Returns the DatabaseType.TypeValue object that represents the database type.
Returns a SQL DDL statement to generate a table based on a SELECT query from an existing table.
Returns a SQL DDL statement to generate a table based on a SELECT query from an existing table. For most databases, this is something like "CREATE TABLE destinationTable AS SELECT columns FROM sourceTable"
Returns a SQL DDL statement to generate a table based on a SELECT query from an existing table.
Returns a SQL DDL statement to generate a table based on a SELECT query from an existing table. For most databases, this is something like "CREATE TABLE destinationTable AS SELECT columns FROM sourceTable whereClause"
Returns a SQL DDL statement to generate a table or view based on a SELECT query from an existing table.
Returns a SQL DDL statement to generate a table or view based on a SELECT query from an existing table. For most databases, this is something like "CREATE TABLE destinationTable AS SELECT columns FROM sourceTable" or "CREATE VIEW destinationTable AS SELECT columns FROM sourceTable", depending on the isView parameter
Returns a SQL DDL statement to generate a table or view based on a SELECT query from an existing table.
Returns a SQL DDL statement to generate a table or view based on a SELECT query from an existing table. For most databases, this is something like "CREATE TABLE destinationTable AS SELECT columns FROM sourceTable whereClause" or "CREATE VIEW destinationTable AS SELECT columns FROM sourceTable whereClause", depending on the isView parameter
Returns a SQL DDL statement to generate a view based on a SELECT query from an existing table.
Returns a SQL DDL statement to generate a view based on a SELECT query from an existing table. For most databases, this is something like "CREATE VIEW destinationTable AS SELECT columns FROM sourceTable"
Returns a SQL DDL statement to generate a view based on a SELECT query from an existing table.
Returns a SQL DDL statement to generate a view based on a SELECT query from an existing table. For most databases, this is something like "CREATE VIEW destinationTable AS SELECT columns FROM sourceTable [whereClause]"
Returns a SQL DDL statement to drop a table if it exists, and optionally, cascade the drop to dependent tables.
Returns a SQL DDL statement to drop a table if it exists, and optionally, cascade the drop to dependent tables. For most databases, this is something like "DROP TABLE IF EXISTS tableName [CASCADE]"
Returns a SQL DDL statement to drop a view if it exists, and optionally, cascade the drop to dependent views.
Returns a SQL DDL statement to drop a view if it exists, and optionally, cascade the drop to dependent views. For most databases, this is something like "DROP VIEW IF EXISTS viewName [CASCADE]"
Returns the expression for modulo division for this database.
Returns the expression for modulo division for this database. This differs widely among databases. For example, in PostgreSQL, this is "dividend % divisor". But in Oracle, this is "MODULO(dividend, divisor)". For this reason, we must pass in the expressions used for dividend and divisor.
Returns the name of the standard deviation function to be used for this database.
Returns the name of the standard deviation function to be used for this database. For example, in PostgreSQL, this is "stddev". Note that this is just the function name, and does not include the argument. A typical call would be "stddev(expression)".
Returns the name of the variance function to be used for this database.
Returns the name of the variance function to be used for this database. For example, in PostgreSQL, this is "variance". Note that this is just the function name, and does not include the argument. A typical call would be "variance(expression)".
Character or String to use when quoting identifiers.
Character or String to use when quoting identifiers. Typically, this is a double-quote (for PostgreSQL and other databases), but can be other characters or even Strings for other platforms.
Wraps an identifier in the appropriate quote character to preserve case and special characters.
Wraps an identifier in the appropriate quote character to preserve case and special characters. If there is no quoting mechanism for this database type, just return the argument.
identifier name to be quoted
Wraps a schema and table or view name in the appropriate quote character to preserve case and special characters.
Wraps a schema and table or view name in the appropriate quote character to preserve case and special characters. If schemaName is unspecified, quote only the objectName. Uses quoteIdentifier() for quoting.
If true, subqueries must be aliased.
If true, subqueries must be aliased.
Wraps a column name in the appropriate quote character to preserve case and special characters.
Wraps a column name in the appropriate quote character to preserve case and special characters. If there is no quoting mechanism for this database type, just return the argument. Note: Deprecated -- please use quoteIdentifier instead.
name to be escaped.
(Since version 2016-04-22) Please use quoteIdentifier instead [Paul]