Share via

modDropSchema

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

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'