Filter
Top Products
Deleting a trigger definition (DROP TRIGGER statement)
To delete a trigger definition, use the DROP TRIGGER statement.
Example:
Delete trigger ORDER_TRIGGER.
Adding a procedure routine definition (CREATE PROCEDURE statement)
To add a procedure routine, use the CREATE PROCEDURE statement. For details about how to specify the CREATE
PROCEDURE statement, see 2.6 "Defining a Logical Structure."
Example:
Add PROC002 to the STOCKS schema.
Deleting a procedure routine definition (DROP PROCEDURE statement)
To delete a procedure routine, use the DROP PROCEDURE statement. If the schema has another procedure routine
that calls the procedure routine to be deleted, the procedure routine cannot be deleted. To delete all related procedure
routines, specify CASCADE. For details about how to specify the DROP PROCEDURE statement, see 2.6 "Defining a
Logical Structure."
Example:
Delete PROC002 from the STOCKS schema.
Adding a function routine definition (CREATE FUNCTION statement)
To add a function routine, use a function routine definition statement. For details on how to specify the function routine
definition statement, see 2.6 "Defining a Logical Structure."
121