Aqua Data Studio 15.0.0-dev-94.
Database Version: Paraccel 4.0.2.4
Build #: 35832.
Built on: 2014-Feb-04 11:25:19 AM.
Connect to Paraccel database.
Create the following table:
CREATE TABLE "public"."test" (
"col1" varchar(25) NULL ENCODE RAW,
"col2" varchar(25) NULL ENCODE RAW,
"col3" int4 NULL ENCODE RAW,
"col4" int4 NULL ENCODE RAW
)
DISTSTYLE EVEN
GO
Table Created Successfully.
Now go to server tree node,select paraccel database,expand it,select the database in which table test is created,expand it
for example here the table is created in "test" database.
Select schema "public",expand it select table folder,expand it,select table test,right click on it and select option
alter table,alter table window is displayed.
Go to General Tab in alter table window,add column "col5" and take datatype "integer". Here it is observe that paraacel db does not support identity when we alter table,but here identity field options are enable when we alter table.
