modRemoveWorkflow

See Also

[@TableID =] 'id', 

[@Cascade =] 'cascade', 

[@modProcessTable =] 'process'

Removes workflow tables associated with a user table. Exists in the solution database.

Parameters

[@TableID =] 'id'

Table ID.

[@Cascade =] 'cascade'

When True, removes workflow tables for all dependant detail tables. When False, removes workflow only for the current table.

[@modProcessTable =] 'process'

When True, reapplies Access Workflow Designer core features to a table after workflow has been removed.

Remarks

The associated workflow table and workflow status column are removed from the Access Workflow Designer solution database schema. If the cascade parameter is True and the table has child tables, this process applies recursively to those tables as well. No workflow tables that are removed from Access Workflow Designer schema are deleted.

Example

The following example removes workflow tables for the Category table and dependent tables.

EXEC modRemoveWorkflow 'Category', True, True