Filter
Top Products
Example:
Defines function routine USER002 to schema STOCKS.
Deleting a function routine definition (DROP FUNCTION statement)
To delete a function routine, use a function routine deletion statement. If a function routine to be deleted is specified in
an SQL statement related to a procedure routine or trigger, the function routine cannot be deleted. However,
specifying CASCADE deletes all related definitions.
Example:
Deletes USER001 from schema STOCKS.
Changing a comment definition
Comment definitions for tables and columns can be changed with the ALTER TABLE statement. An example follows.
Example:
Change the table comment definition.
Example:
Change the column comment definition.
122