2 Replies Latest reply: Jul 24, 2013 4:42 AM by David Last-Oracle RSS

    unable to create constraint name

    don123

      Hi,

       

      Please see the DDL generated from oracle data modeler from relational model.

      There is no CHECK constraint name in the SQL. I have created a domain with Check_Constraint by using Tools->Domain Administration.

      Kindly inform how to create this in the model..

       

       

      CREATE TABLE sup_twdm

          (

           feattype NUMBER (2) CHECK ( feattype=42) ,

           idnumber VARCHAR2 (5 CHAR) ,

           idarpt VARCHAR2 (5 CHAR)

          )

      ;

       

      Thanks