modRemoveWorkflow
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 workflow tables associated with a user table. Exists in the workflow-enabled database.
[@TableID =] 'id',
[@Cascade =] 'cascade',
[@modProcessTable =] 'process'
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 Workflow Designer for SQL Server core features to a table after workflow has been removed.
Remarks
The associated workflow table and workflow status column are removed from the Workflow Designer for SQL Server application 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 Workflow Designer schema are deleted.
Example
The following example removes workflow tables for the Category table and dependent tables:
EXEC modRemoveWorkflow 'Category', True, True
See Also
Stored Procedures | Workflow Application Infrastructure | ModSystem Database Tables | Workflow-Enabled Database Tables | Views