Fujitsu 5.0L10 Manual De Usuario
Chapter 3 Database Definition Alteration and
Deletion
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.
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.
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:
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