modDropProcedures

See Also

[@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'