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.
Set redshifts extraction to allow for a table to not have columns during extraction. This means that the scripting will create a create / drop / alter table without columns if there is a table without columns. This table without columns is a bug on the redshift database though and the script created for a broken object will return sql exceptions when executed.