modDropSchema

See Also

[@DBName =] 'dbname', 

[@OverWrite =] 'False'

Removes all the solution objects (tables, stored procedures, and views) from a solution database. Exists in the modSystem database.

Parameters

[@DBName =] 'dbname'

The name of the solution database.

[@OverWrite =] 'False'

Indicates whether the stored procedure should delete existing solution tables. When False (default), the procedure produces an error if any solution tables are found in the database. When True, the procedure deletes all the solution tables.

Remarks

Removes all the objects created when Access Workflow Designer features were applied to a database. Deletes the following tables: modObjects, modObjectTypes, modColumns, modProperties, and modPermissions. After the execution, the database is no longer recognized as a team solution.

Example

The following example removes tables and views from the Issue Tracking database without prompting for whether solution tables exist.

EXEC modDropSchema 'IssueTracking', 'True'