This discussion is archived
1 Reply Latest reply: Aug 6, 2013 7:24 AM by AM RSS

4.0EA1 Exporting table DDL puts Not Null constraint as alter statement

AM Newbie
Currently Being Moderated

This was an issue with in release 3.2.10.09 as well

 

Exporting tables with not null constraints exports DDL with not null constraint as Alter table statement. In browser right click on table -> Quick DDL -> Save to Worksheet. Issue is same when table is exported by other options.

This has undesirable effect when table is reference partitioned then the create table command as constructed by export can not be played as Not Null constraint is not inline.

 

This is not an issue when viewing table SQL in table information window.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points