Filter
Top Products
Deleting procedure routines
To delete a procedure routine, use the DROP PROCEDURE statement. When a procedure routine is deleted, the
privilege information for the procedure is also deleted.
Example:
Delete PROC002 from the STOCKS schema.
Deleting function routine definitions
To delete a function routine, use the DROP FUNCTION statement. When a function routine is deleted, privilege
information of the function routine is also deleted.
Example:
Deletes USER001 from schema STOCKS.
Deleting triggers
To delete a trigger, use the DROP TRIGGER statement.
Example:
Delete the trigger belonging to the STOCKMN_DB.
Deleting views
To delete a view, use the DROP VIEW statement.
Example:
Delete the view belonging to STOCKMN_DB.
The view specified in the DROP VIEW statement is deleted.
Deleting tables
To delete a table, use the DROP TABLE statement. When a table is deleted, the privilege information for the table is
also deleted.
136