× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
abhishekj(*) reported 2014-02-06T13:59:34Z  · tariqrahiman last modified 2014-05-05T20:49:50Z

Unable to drop table when right click on drop table option in redshift db.


Priority Low
Complexity Unknown
Component DB - RedShift
Version 15.0
Aqua Data Studio 15.0.0-dev-94.
Database:Redshift.
Build #: 35832.
Built on: 2014-Feb-04 11:25:19 AM.
 
Create the following table:
 
CREATE TABLE "public"."test_p"  ( 
"col1" varchar(25) NULL,
"col2" varchar(25) NULL,
"col3" varchar(25) NULL 
)
GO
 
Table Created Successfully.
 
From Server Tree Node,select redshift database,expand it,select database option,expand it.
 
Select the database in which table test is created for example,here table "test_p" is created in "test" db,expand it
select schema "public",expand it,select table "test" right click on it and select option alter table,under alter table
go to general tab.
 
Right click on each column and select option "Delete column",and click on alter button.
 
All the columns in the table are deleted successfully.
 
Now select table "test_p" right click on it and select option "Drop"
 
Here it is observe that no drop table option is diplayed when we select drop option and we are not able to drop the table.
 
Refer to screenshot1.jpeg.
 
When we execeute drop table query on query analyzer window table gets drop successfully.
 
Refer to screenshot2.jpeg.
 
 
 
1 attachment

Issue #11674

Closed
Fixed
Resolved 2014-02-10T21:46:12Z
 
 
Completion
No due date
Fixed Build v15.0.0-dev-101
No time estimate

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