In the subsequent steps, let's look at the details for deleting a Workspace in Workspace Designer:
- Click a Workspace card in Workspace Designer.
- Click the Delete (
) icon to delete the Workspace.
3. When the Workspace deletion is initiated, a warning message is displayed. Click OK for the warning message.
Canvas Studio enables the developer to select the sub workspaces that needs to be deleted along with the Workspace. Deleting the sub workspace removes the sub workspace from the database.
- By default, all the sub workspaces will be selected. Clear the check box adjacent to the subworkspace(s) that you do not want delete. Click Delete to delete the selected sub workspaces.
On successful deletion, Canvas Studio generates rollback script and delete query for the deleted Workspace. - Rollback query: Rollback query can be used to re-create the deleted Workspace, if required.
- Delete query: Delete query can be used to delete the same Workspace from other database, if it exists and needs to be removed.
Generated rollback script and delete query will be available in Canvas workbench folder.
For example,
Path: D:\Canvas\CodeGen\generated\wdktemplate\1.0\workspace
File | File Name Format | Example |
Rollback script | Workspace ID_Day_Date@time_ROLLBACK.sql | TRANSACTIONSUMMARY536_Mon_ 22-Jan-2018@13-05-47_ROLLBACK.sql |
Delete query | Workspace ID_Day_Date@time.sql | TRANSACTIONSUMMARY536_Mon_ 22-Jan-2018@13-05-47.sql |