Share via


modRemoveTable

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 a user table from the workflow schema registry along with any related tables. Exists in the workflow-enabled database.

 [@TableID =] 'id', 
[@Cascade =] 'cascade'

Parameters

  • [@TableID =] 'id'
    Table ID.
  • [@Cascade =] 'cascade'
    When True, removes all dependent workflow-enabled tables. When False, an error appears indicating the list of dependent tables.

Remarks

This process also removes any related workflow tables and permissions tables. All field entries for this table in the modColumns table are deleted. If the cascade parameter is True and the table has child tables, this process applies recursively to those tables as well. For dependent tables, the procedure returns either the list of those objects for you to remove (cascade = False) or removes the objects (cascade = True).

Example

The following example removes the Category table and all dependent tables:

EXEC modRemoveTable 'Category'

See Also

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