Dropping user-defined functions

Once you create a user-defined function, it remains in the database until it is explicitly removed. Only the owner of the function or a user with DBA authority can drop a function from the database.

For example, to remove the function fullname from the database, enter:

DROP FUNCTION fullname
Related concepts
Creating user-defined functions
User-defined function restrictions
Compile and link switches for building dynamically linkable libraries
SQL data types
Related tasks
Calling user-defined functions
Granting and revoking permissions


Created November 2, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com