modCreateSchema

See Also

[@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'