Share via

modCreateSchema

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

Installs all the tables and views in a workflow-enabled database. Exists in the modSystem database.

[@DBName =] 'dbname', 
[@OverWrite =] 'False'

Parameters

  • [@DBName =] 'dbname'
    Name of the workflow-enabled database.
  • [@OverWrite =] 'False'
    Indicates whether the stored procedure should overwrite existing application tables. When False (default), the procedure produces an error if any application table is found in the database. When True, the procedure replaces any existing application table.

Remarks

Creates the following tables in the workflow-enabled database: modObjects, modObjectTypes, modColumns, modProperties, and modPermissions. Creates the modUserList view.

Example

The following example creates tables and views in the Issue Tracking sample database and overwrites existing objects:

EXEC modCreateSchema 'IssueTracking', 'True'

See Also

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