| Table of Contents |
|---|
...
| Operation and Object Type | Packaging FolderFolders (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 use 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 |
Error Handling
Do not put error-handling statements in the SQL scripts.
...
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
...