Share via

modAddTable

  • 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.

Registers a user table and its relation in a table hierarchy in the Workflow Designer for SQL Server schema. Exists in the workflow-enabled database.

[@Name =] 'name', 
[@Type =] 'type',
[@ChildColumn =] 'Ccolumn'
[@ParentID =] 'id',
[@ParentColumn =] 'Pcolumn', 
[@Caption =] 'caption'

Parameters

  • [@Name =] 'name'
    The table name. The type is sysname with no default.
  • [@Type =] 'type'
    Table type; 'DM' for main tables and 'DD' for detail tables.
  • [@ChildColumn =] 'Ccolumn'
    Column in the child table that defines the main detail relationship. Applies only to detail tables. The type is sysname with no default.
  • [@ParentID =] 'id'
    ID of the parent table. Applies only to detail tables.
  • [@ParentColumn =] 'Pcolumn'
    Column in the parent table that defines the main-detail relationship. Applies only to detail tables. The type is sysname with no default.
  • [@Caption =] 'caption'
    The friendly name of the registered table. The type is nvarchar with no default.

Remarks

Adds a user table to the Workflow Designer for SQL Server schema for the workflow application. The table can be a main table or a detail table. For detail tables, modAddTable registers the two columns that define the hierarchical relationship. The user table is not modified by this procedure.

Example

The following example registers the detail table, Orders, in the Workflow Designer for SQL Server application schema. The Orders table is related to the Customers table by the relationship: 'Customers.Id = Orders.CustId'.

EXEC modAddTable 'Orders', 'DD', 'CustId', 2, 'Id', 'Orders submitted by our customers'

See Also

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