DDL

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)