Fujitsu J2X0-2273-01EN User Manual

Example: 

Delete the tables belonging to STOCKMN_DB. 

 

 

 

The tables specified in the DROP TABLE statements are deleted. 

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. 

 

 

 

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. 

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