Aqua Data Studio 15.0.0-dev-91

Database Version:Redshift db.

Build #: 35775

Built on: 2014-Jan-30 03:24:03 PM

 

Connect to Redshift database.

Create the following table.

CREATE TABLE "testredshift"."character_data_type"  (

                "col1"    varchar(25) NULL DEFAULT 'abhi'::character varying,

                "col2"    char(25) NULL

                )

GO

Table Created Successfully.

Go to Server Tree Node, Select Amazon Database, expand it.

Select the database "test" in which table character_data_type is created, expand it, select schema "testredshift",expand it.

Select the table "character_data_type" right click on it and select option Alter Table.

Go to general tab in alter table, and select any column "col1" or "co2" and set it to Not Null.

Go to Preview Sql Tab.

Following script is generated in Preview Sql Tab:

ALTER TABLE "testredshift"."character_data_type" ALTER "col1" SET NOT NULL

GO

Now Click on Alter Button.

It will display the message "ALTER COLUMN SET NOT NULL is not supported".

Refer Screenshot3.jpeg

Redshift database does not allow column to set to not null,then this option should be grey out or should be made uneditable like in paraccel db.

Refer Screenshot2.jpeg.