modAddTable

See Also

[@Name =] 'name', 

[@Type =] 'type',

[@ChildColumn =] 'Ccolumn'

[@ParentID =] 'id',

[@ParentColumn =] 'Pcolumn', 

[@Caption =] 'caption'

Registers a user table and its relation in a table hierarchy in the Access Workflow Designer schema. Exists in the solution database.

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 Access Workflow Designer schema for the team solution. The table can be a main table or a detail table. For detail tables, indicates 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 Access Workflow Designer solution 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'