SQL Statements (DDL)
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The Data Definition Language (DDL) is used to CREATE, ALTER, and DROP various object types in the database catalog. jOOQ supports an increasing number of these operations natively, and also adds synthetic operation support for convenience.
While many DDL statements are supported natively, and have a 1:1 correspondence to the jOOQ API's representation, dialects differ in many subtle ways when it comes to DDL statement support. These differences may include:
- Different keywords to mean the same thing. For example, the keywords
MODIFYmay be used when altering columns or other attributes in a table.
- Different statements instead of subclauses. For example, some dialects may choose to support
RENAME [object type] .. TO ..statements instead of making the rename operation a subclause of
ALTER [object type] .. RENAME TO ..
- Some syntax may not be supported, or not be supported consistently, such as the various
IF NOT EXISTSclauses. Emulations are possible using the dialect's procedural language
Because of these many differences, the jOOQ manual will not list each individual native SQL representation of each jOOQ API call. Also, some optional clauses may exist, such as the
IF EXISTS or
OR REPLACE clauses, which can easily be discovered from the API. The manual will omit documenting these clauses in every example.
- The ALTER statement
- ALTER SEQUENCE
- ALTER TABLE
- The CREATE statement (new)
- CREATE INDEX (new)
- CREATE SEQUENCE (new)
- CREATE TABLE (new)
- CREATE VIEW (new)
- The DROP statement
- DROP INDEX (new)
- DROP SEQUENCE (new)
- DROP TABLE
- DROP VIEW (new)
- The TRUNCATE statement
|The jOOQ User Manual : SQL building : SQL Statements (DDL)||previous : next|