3 Replies Latest reply: Mar 17, 2014 8:43 AM by Kent Graziano RSS

    How can I Data Modeler not to generate NNC_ constraints on tables?

    Matze1969

      Hi all,

       

      unfortunately I haven't found the answer using Google ;-)

       

      When I generate my DDL scripts on my model on some tables Data Modeler (version 4.0.0) automatically generates "NNC_" constraints on table columns e.g.:

       

      CREATE TABLE STG_DURCHGANGSKNOTEN

        (

          ID                   NUMBER CONSTRAINT NNC_STG_DURCHGANGSKNOTENv1_ID NOT NULL ,

          Kilometrierung       VARCHAR2 (20) CONSTRAINT NNC_STG_DURCHGANGSKNOTENv1_Kilometrierung NOT NULL ,

          Letzte_Aenderung     DATE CONSTRAINT NNC_STG_DURCHGANGSKNOTENv1_Letzte_Aenderung NOT NULL ,

          Knotentyp            VARCHAR2 (100) CONSTRAINT NNC_STG_DURCHGANGSKNOTENv1_Knotentyp NOT NULL ,

          Name                 VARCHAR2 (100) ,

          BZ_Bezeichner        VARCHAR2 (100) ,

          GUI_Bezeichner       VARCHAR2 (100) ,

          Spurplanabschnitt_ID NUMBER CONSTRAINT NNC_STG_DURCHGANGSKNOTENv1_Spurplanabschnitt_ID NOT NULL ,

          XML_Document XMLTYPE

        );

       

      How can I avoid this? I just like to get something like this:

       

      CREATE TABLE STG_DURCHGANGSKNOTEN

        (

          ID                   NUMBER  NOT NULL ,

          Kilometrierung       VARCHAR2 (20)  NOT NULL ,

          Letzte_Aenderung     DATE  NOT NULL ,

          Knotentyp            VARCHAR2 (100)  NOT NULL ,

          Name                 VARCHAR2 (100) ,

          BZ_Bezeichner        VARCHAR2 (100) ,

          GUI_Bezeichner       VARCHAR2 (100) ,

          Spurplanabschnitt_ID NUMBER  NOT NULL ,

          XML_Document XMLTYPE

        );

       

      Thanks

      Matthias