Fujitsu J2X0-2273-01EN Server User Manual


 
Example:
Delete the tables belonging to STOCKMN_DB.
The tables specified in the DROP TABLE statements are deleted.
Deleting sequences
To delete a sequence, use the DROP SEQUENCE statement. When a sequence is deleted, privilege information of
the sequence is also deleted.
Example:
Deletes a sequence belonging to the stock management database.
Deleting schemas
To delete a schema, use the DROP SCHEMA statement. When a schema is deleted, the privilege information for the
schema is also deleted.
Example:
Delete the schema belonging to STOCKMN_DB.
The schema specified in the DROP SCHEMA statement is deleted.
Deleting database spaces
To delete a database space, use the DROP DBSPACE statement. When a database space is deleted, the privilege
information for the database space is also deleted.
Example:
Delete the database spaces belonging to STOCKMN_DB.
137