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.

Removes all the application objects (tables, stored procedures, and views) from a workflow-enabled database. Exists in the modSystem database.

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

Parameters

  • [@DBName =] 'dbname'
    The name of the workflow-enabled database.
  • [@OverWrite =] 'False'
    Indicates whether the stored procedure should delete existing application tables. When False (default), the procedure produces an error if any application tables are found in the database. When True, the procedure deletes all the application tables.

Remarks

Removes all the objects created when Workflow Designer for SQL Server features were applied to a database. Deletes the following tables: modObjects, modObjectTypes, modColumns, modProperties, and modPermissions. After the procedure executes, the database is no longer recognized as a workflow application.

Example

The following example removes tables and views from the Issue Tracking sample database without prompting for whether application tables exist:

EXEC modDropSchema 'IssueTracking', 'True'

See Also

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