Fujitsu J2X0-2273-01EN User Manual

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 

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 

 

 

·  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). 

 

·  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