Share via

Creating a Table Hierarchy

  • Article

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.

The table hierarchy in the Workflow Designer for SQL Server is the set of all the tables that are used in the workflow application and the relationships between those tables. The hierarchy is displayed graphically under the Tables folder of the Solution Explorer. You create a table hierarchy by adding a main table to the workflow project.

Main tables are database tables that contain the primary information for your workflow application. These are typically tables to which you want to add workflow and row-level security. There can be multiple main tables in a database.

To create a table hierarchy

  1. Open your database in Microsoft® Office XP Developer.
  2. Select the Project node in the Solution Explorer.
  3. Open the Project menu, and click Add New Item.
  4. Double-click the Add Main Table icon in the Add New Item dialog box.
  5. Select the table to which you want to add workflow from the list. All tables that have primary key or foreign key relationships with the designated main table are included automatically in the table hierarchy as either detail or lookup tables.

To view a table hierarchy

  1. Expand the Tables folder in the Solution Explorer.
  2. To see the detail or lookup tables associated with the main tables, expand the main table.

See Also

Defining Hierarchy Schema | Adding Detail and Lookup Tables | Removing User Tables