The basic features of Daffodil DB under Data Definition Language (DDL) are:
- Alter table Add/Drop Constraints & Columns
- Create/Drop Sequence
- Create/Drop Database
- Create/Drop Domain
- Create/Drop Procedure
- Create/Drop Function
- Create/Drop Trigger
- Create/Drop Index
- Create/Drop Schema
- Create/Drop Table
- Create/Drop Read-Only Views
- Create/Drop User, Roles
- Grant/Revoke Privileges
- Includes: Default Values, Null, Primary Key, Foreign Key, Check Constraints, Full Referential Integrity
- Variable Page Size for Individual Tables And Indexes as well as BLOB/CLOB Columns (Auto Increment)