Removing User Tables
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.
If you no longer want to include a table in the table hierarchy, you can remove it. When Workflow Designer for SQL Server removes a table from the hierarchy, the table remains in the database but is no longer available to the workflow application.
If the table you try to remove has a workflow process based on it, you receive a message prompting you to delete the dependent objects before you remove the table. When you delete a workflow process, it is deleted from the database and not simply removed from the application in the way tables are.
To remove a table from the hierarchy
- In the Solution Explorer, expand the Tables folder. To see the detail or lookup tables, expand the main table nodes.
- Select a table, and then on the Edit menu, click Remove.
- If there are dependent objects, such as detail and lookup tables or workflow processes, you are asked to verify that you want to remove all of these objects.
See Also
Defining Hierarchy Schema | Creating a Table Hierarchy | Adding Detail and Lookup Tables