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.

[@DBName =] 'dbname', 

[@OverWrite =] 'False'

Installs all the tables and views in a solution database. Exists in the modSystem database.

Parameters

[@DBName =] 'dbname'

Name of the solution database.

[@OverWrite =] 'False'

Indicates whether the stored procedure should overwrite existing solution tables. When False (default), the procedure produces an error if any solution table is found in the database. When True, the procedure replaces any existing solution table.

Remarks

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

Example

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

EXEC modCreateSchema 'IssueTracking', 'True'