Delete a Table
You delete user tables from a specific database using the Instance Explorer and the Delete Table dialog.
To delete a table
1. Drill down through the connected installation in the Instance Explorer, open the Databases folder, and locate the database containing the table you want to delete.
2. Right-click the user table you want to delete and select Delete from the context menu.
The Delete Table dialog opens.
3. Select the update policy to use:
Restrict
Aborts the operation if there are any tables that depend on the table being deleted
Cascade
Deletes all dependent tables
4. Click OK to confirm the deletion.
The Delete Table dialog closes, and the table is removed from the Instance Explorer.