Start a new topic

DDL generation without constraints in Netezza

Hi, 

Is there any way to format the DDL or create it without constraints embedded in it?


for example - DbVisualizer V12.0.1 format 

CREATE TABLE TEST 

(

COL1 INTEGER NOT NULL 

COL2 NVARCHAR(10) NULL 

CONSTRAINT  TEST_PK PRIMARY KEY (COL1)

DISTRIBUTE ON RANDOM;


Derised Format:


CREATE TABLE TEST 

(

COL1 INTEGER NOT NULL 

COL2 NVARCHAR(10) NULL 

DISTRIBUTE ON RANDOM;


ALTER TABLE TEST ADD CONSTRAINT  TEST_PK PRIMARY KEY (COL1);


I am using V12.0.1 pro. Please let me know if you need any additional info 



1 Comment

Hi,


At the moment, this is unfortunately not supported. However, we have received a few requests for a more flexible way to generate the DDL. I will add your vote for this improvement, thus increasing the priority to address it.


Thanks for taking the time to raise the issue!


Regards

Peer

Login or Signup to post a comment