Share via

modDropProcedures

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Removes all the Workflow Designer for SQL Server stored procedures from a workflow-enabled database. Exists in the modSystem database.

[@DBName =] 'dbname',
[@OverWrite =] 'False'

Parameters

  • [@DBName =] 'dbname'
    Name of the workflow-enabled database
  • [@OverWrite =] 'False'
    Indicates whether the stored procedure should delete existing application stored procedures. When False (default), the procedure produces an error if any application stored procedures are found in the database. When True, the procedure deletes all application stored procedures.

Remarks

Removes all the mod* stored procedures created when core features were added to a workflow-enabled database.

Example

The following example removes Workflow Designer stored procedures from the Issue Tracking sample database without prompting for whether application tables exist:

EXEC modDropSchema 'IssueTracking', 'True'

See Also

Stored Procedures | Workflow Application Infrastructure | ModSystem Database Tables | Workflow-Enabled Database Tables | Views