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