modRemoveTable

See Also

[@TableID =] 'id', 

[@Cascade =] 'cascade'

Removes a user table from the Access Workflow Designer solution database schema registry and any solution-related tables. Exists in the solution database.

Parameters

[@TableID =] 'id'

Table ID.

[@Cascade =] 'cascade'

When True, removes all dependent solution 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'