× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
braddegenaars reported 2014-07-25T02:17:25Z  · NielsGron last modified 2014-11-21T00:40:10Z

Conditional Drop / Conditional Drop and Create Features


Priority Minor
Complexity Unknown
Component Script Object
Version Future - .9

It would be a time saver for me if you would implement one or both of these features.  First, many times when I modify a table in my dev environment I need to drop and recreate that table in the test and production environments when migrating.  In some cases that table will already exist at the target and in some cases it won't.  Ideally, I'd like to see an option when right clicking a table/function/procedure/view and choosing "Script object to Window As Conditional Drop & Create","Script object to New Window As Conditional Drop & Create", etc.

In addition, I think offering the ability to Script object As Conditional Drop by itself would also be useful instead of or in addition to simply the DROP scripting option.

In case my request for Conditional Drop is misunderstood, I'm simply looking for something like this:

IF OBJECT_ID('dbo.TABLENAME') IS NOT NULL
DROP TABLE [dbo].[TABLENAME]
 
IF OBJECT_ID('dbo.PROCEDURENAME') IS NOT NULL
DROP PROCEDURE [dbo].[PROCEDURENAME]
 

etc.

Issue #12444

Closed
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017