 |  LoginProducts  SalesSupportDownloadsAbout |
| Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 SQL Manual » DDL Statements » DROP FUNCTION |
DROP FUNCTIONDrops an existing function.
Syntax
Usage
Use this statement to drop a function from a database.
Dropping a function can cause other jobs, functions, procedures, views, triggers, constraints, or column defaults to generate an error if they refer to the function being dropped.
Examples
Required Privileges
The current user must be granted the DROP privilege on the current database in order to execute this statement. Please see the User Security topic for more information.
SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:
Syntax
DROP FUNCTION <Name>
Usage
Use this statement to drop a function from a database.
Dropping a function can cause other jobs, functions, procedures, views, triggers, constraints, or column defaults to generate an error if they refer to the function being dropped.Examples
-- The following statement drops the LookupTaxRate function. DROP FUNCTION "LookupTaxRate"
Required Privileges
The current user must be granted the DROP privilege on the current database in order to execute this statement. Please see the User Security topic for more information.
SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:
| Deviation | Details |
| RESTRICT and CASCADE | ElevateDB does not support the RESTRICT or CASCADE clauses. |
More Support Options
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ?  E-mail us at info@elevatesoft.com |
