1 Reply Latest reply: Aug 6, 2013 9:24 AM by AM RSS

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


      This was an issue with in release 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.