Modifying SQL-Defined Databases › What You Can Modify

What You Can Modify

You can modify an SQL-defined database by:

• Adding or dropping tables
• Modifying table components
• Adding, modifying, or dropping indexes and referential constraints
• Adding, modifying, or dropping schemas
• Adding or dropping views
• Adding, modifying or dropping SQL routines
• Adding or dropping keys associated with SQL routines

Note: For more information about maintaining physical definitions, see the chapter “Modifying Physical Database Definitions".