Aqua Data Studio 15.0.0-dev-256
Build #: 37570
Built on: 2014-Apr-28 05:22:50 PM
OS Environment: Windows 8(x64 bit)
Database : Amazon Redshift
Steps to reproduce:
1. Connect to Amazon Redshift server --> Go to databases tree node
2. Select any schema --> Click on Tables folder --> Select Create Table option.
3. In Create Table window
Create column of 'int' datatype and column property pane set
Identity to Yes
Identity Seed to 1001
Identity Step to 1
4. Switch to Preview SQL tab, it generates SQL with Identity Column property.
5. Click on Create button.
6. Now right click on above created table and select Table property option.
7. Here we observe that in column property pane Identity property is set to No.
Or create table by below script
CREATE TABLE "red"."Employee" (
"ID" int NOT NULL IDENTITY (1, 1001),
"Name" varchar(25) NULL,
"Dept" varchar(25) NULL,
"Salary" int NULL
)
after executing above script continue to step 6.
Please see attached screenshot.
@chandradip : This is now fixed in 15.0.0-dev-269. There is a related issue which is also fixed. Test the cases in your screenshot as well.