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.

[@DBName =] 'dbname',

[@OverWrite =] 'False'

Removes all the Access Workflow Designer stored procedures from a solution database. Exists in the modSystem database.

Parameters

[@DBName =] 'dbname'

Name of the solution database

[@OverWrite =] 'False'

Indicates whether the stored procedure should delete existing solution stored procedures. When False (default), the procedure produces an error if any solution stored procedures are found in the database. When True, the procedure deletes all solution-stored procedures.

Remarks

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

Example

The following example removes Access Workflow Designer stored procedures from the Issue Tracking database without prompting for whether solution tables exist.

EXEC modDropSchema 'IssueTracking', 'True'