| Table of Contents |
|---|
...
| Operation and Object Type | Packaging Folders (fixed folders) | Package Methods (flexible folders) | Archived | Notes |
|---|---|---|---|---|
| CREATE/ALTER/DROP DATABASE LINK | sql_direct | direct | Yes | |
| CREATE/ALTER/DROP FUNCTION | function | storedlogic | No | |
| CREATE/ALTER/DROP INDEX | | convert, ddl_direct, direct | Yes | |
| CREATE/ALTER/DROP PROCEDURE | procedure | storedlogic | No | |
| CREATE/ALTER/DROP QUEUE | sql_direct | direct | Yes | |
| CREATE/ALTER/DROP SEQUENCE | | convert, ddl_direct, direct | Yes | |
| CREATE/ALTER/DROP SYNONYM | | convert, ddl_direct, direct | Yes | For ALTER and CREATE OR REPLACE synonym onlyuse ddl_direct or sql_direct/direct. (Do not use ddl/convert with ALTER and CREATE OR REPLACE synonym.) |
CREATE/ALTER/DROP TABLE | | convert, ddl_direct, direct | Yes | |
| CREATE/ALTER/DROP TRIGGER |
| storedlogic | No | |
| CREATE/ALTER/DROP TYPE | sql_direct | direct | Yes | |
| CREATE/ALTER/DROP VIEW |
| storedlogic | No | |
| CREATE/ALTER/DROP VIEW INDEX | | convert, ddl_direct, direct | Yes | |
| RENAME <DB_OBJECT> | sql_direct | direct | Yes |
...
| Operation | Packaging Folder (fixed folders) | Package Method (flexible folders) | Archived |
|---|---|---|---|
| INSERT, UPDATE, DELETE, SELECT | data_dml | data_dml | Yes |
| GRANT, REVOKE | sql_direct | direct | Yes |
...
See also these pages for overview of packaging workflows, guidelines for writing scripts, and which packaging methods or folders to use for which types of changes:
Writing SQL Scripts for Datical DBLiquibase Enterprise
...