Procedure will check if function with the given name exists in the database and will attempt to drop it.
Arguments
-
v_Object_Name – Function Name, SYSNAME.
-
v_Signature – Signature, Variable Character (128). Optional. Reserved parameter.
Note:
Supported in SQL Server versions at this time.
Examples
SQL Server
EXECUTE DBTD_DROP_FUNC_IF_EXISTS 'FN_GET_PRODUCT_ID' ,'';
EXECUTE DBTD_DROP_FUNC_IF_EXISTS 'MyServer.MyDatabase.MySchema.FN_GET_PRODUCT_ID';
See Also