Chapter 3 Database Definition Alteration and Deletion
A database can be used after it has been created. To use the database, create an application program. For
information about how to use an application program to process a database, refer to the RDB User's Guide:
Application Programs Development.
After a database has been created, the user may need to add data items to the designed database. Alternatively, data
items may become unnecessary.
This chapter explains how to alter and delete a database definition. The explanations are given in the following order:
3.1 Altering a Database Definition
3.2 Deleting a Database
3.1 Altering a Database Definition
The user alters a database definition by performing the following operations.
For more information about the SQL statements described in this chapter, refer to the following
manuals:
· SQL Reference Guide
· SQL Beginner's Guide
Altering the logical structure definition:
· Adding a schema definition (CREATE SCHEMA statement).
· Deleting a schema definition (DROP SCHEMA statement).
· Adding a sequence definition (CREATE SEQUENCE statement)
· Deleting a sequence definition (DROP SEQUENCE statement)
· Adding a table definition (CREATE TABLE statement).
· Deleting a table definition (DROP TABLE statement).
· Altering a table definition (ALTER TABLE statement).
· Adding a view definition (CREATE VIEW statement).
· Deleting a view definition (DROP VIEW statement).
· Adding a trigger definition (CREATE TRIGGER statement).
· Deleting a trigger definition (DROP TRIGGER statement).
· Adding a procedure routine definition (CREATE PROCEDURE statement).
· Deleting a procedure routine definition (DROP PROCEDURE statement).
· Adding a function routine definition (CREATE FUNCTION statement)
· Deleting a function routine definition (DROP FUNCTION statement)
· Altering a comment definition.
· Swapping a table (SWAP TABLE statement).
Altering the storage structure definition:
· Adding a table data structure organization (DSO) definition (CREATE DSO statement).
· Deleting a table DSO definition (DROP DSO statement).
· Adding a table data structure instance (DSI) definition (CREATE DSI statement).
· Deleting a table DSI definition (DROP DSI statement).
· Adding an index DSO definition (CREATE DSO statement).
· Deleting an index DSO definition (DROP DSO statement).
· Altering the split value of a DSI definition (ALTER DSI statement).
· Addinging a scope definition (CREATE SCOPE statement).
· Applying a scope definition (APPLY SCOPE statement).
· Releasing a scope definition (RELEASE SCOPE statement).
· Deleting a scope definition (DROP SCOPE statement).
115