Cannot drop, rename, or alter views from GUI in the Object Explorer (4271087)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Cannot drop, rename, or alter views from GUI in the Object Explorer
Description

I am trying to alter, rename, or drop a view using the GUI in the Object Explorer. Doing so, I get the following message:
"Successfully renamed (dropped, altered) the object"
However, when I reopens Toad, the view is not altered, renamed, or dropped depending on which one of the three I was working on.

,
Cause

The failure with ALTER, RENAME, or DROP VIEW GUI can be seen under the following conditions:
1. If a user executes ALTER VIEW with View Details | Data tab opened and that contains data "already", ALTER fails.
2. If a user executes ALTER VIEW with View Details | Data tab opened with and empty data set but will contain data after ALTER VIEW, ALTER fails.
3. Regarding RENAME and DROP VIEW, both seems to work properly before an ALTER is done. Once an ALTER is done, DROP VIEW consistently fails but RENAME might sometimes fail.
Resolution

WORKAROUND: Run the generate script from the GUI directly in the Editor or write your own script.
STATUS: Waiting for fix in a future release of Toad for SQL Server.
Defect ID

ST89448

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title