Aqua Data Studio 15.0.0-dev-86
Database: Amazon Redshift
Build #: 35703
Built on: 2014-Jan-27 10:31:45 AM
Connect to Redshift Database.
Select any database.Expand it.
Select Table folder,right click on it and select option create table.
Create Table window is opened.Create the following table at GUI side of ADS.
CREATE TABLE "public"."project" (
"col1" varchar(25) NULL,
"col2" varchar(25) NULL
)
Go
Table Created Successfully.
Go to Server Tree Node,select redshift database,expand it.
select database and the schema in which "project" table is created,expand the table "project",select the column folder in project table tree node,expand it.
expand the column folder select "col1" right click on it select the option script object to window as :
Here it is observe that we do not have option of alter and drop option is not available,we have only one option of create.
When we compare with PostgresSQL database we do have alter and drop option.
Refer to screenshot5.jpeg.
added drop to menu and scripting. There is no alter table alter column support...