Drops an existing function.
Available in a network database and requires the star$define role.
Parameters:
| Name | Optional | Type | Description |
| function$ | Mandatory | Text | The name of the function to be dropped. |
| arguments$ | Mandatory | Text | Argument signature of the function. |
| cascade$ | Mandatory | Boolean | Indicates if dependent objects can be dropped too. |
Examples:
SELECT drop_function('mysqlfunc','arg1 int'); -- drops function with a single integer argument.
Tips:
- The star$functions view indicates which functions already exist.
Comments
Article is closed for comments.