Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal
< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7
You are here: Manage Databases > Work with Objects > Drop Objects

Drop Objects

Drop One or More Objects

To drop an object

  1. Select one or more objects in the Object Explorer.

  2. Click Drop Object on the toolbar (SHIFT+F10+D). An on the toolbar indicates a drop action.

    Note: When dropping objects in the Object Details pane (right-click an object and select View Details to display) the shortcut key is SHIFT+F10+O.

View the Drop Impact on Dependencies

Note: You can view drop impact on database objects only.

From the Drop window, you can preview the effects that dropping each of your selected objects has on its dependencies (or, conversely, the restrictions that the dependencies put on the drop).

To view the impact of the drop on dependencies

  1. On the Objects page in the Drop window, select an object from the list of objects you intend to drop.

  2. The nodes under the object organize the object's dependencies by impact type (that is, by the effect that the drop has on the dependencies or that the dependencies have on the drop).

Objects restricting drop

As long as these dependencies exist, an attempt to drop the object fails.

Cascaded objects

The drop causes these dependencies to be dropped as well. However, if one of these dependencies has a restrictive dependency, an attempt to drop the object fails.

Inoperative objects

The drop causes these dependencies to become inoperative (no longer available for SQL operations) until the user takes action to recover the dependent objects.

Notes: