0 Replies Latest reply on Apr 5, 2018 4:05 AM by 2850698

    Is there a way to configure how the create table script generated in the SQL tab of table so it is same as the one generated in the DDL pane in editing a table?

    2850698

      I'm using Oracle SQL Developer 17.2.0.188.

       

      I notice that the create table script generated in DDL pane in Edit table will create primary key this way:

       

      CREATE UNIQUE INDEX CISADM.XC404P0 ON CISADM.CI_BFCH_TOUGRP (BF_CD ASC, CHAR_TYPE_CD ASC, CHAR_VAL ASC, TOU_GRP_CD ASC)

      LOGGING

      TABLESPACE CISTS_01

      PCTFREE 10

      INITRANS 2

      STORAGE

      (

        INITIAL 262144

        NEXT 1048576

        MINEXTENTS 1

        MAXEXTENTS UNLIMITED

        BUFFER_POOL DEFAULT

      )

      NOPARALLEL;

       

       

      ALTER TABLE CISADM.CI_BFCH_TOUGRP

      ADD CONSTRAINT SYS_C00290269 PRIMARY KEY

      (

        BF_CD

      , CHAR_TYPE_CD

      , CHAR_VAL

      , TOU_GRP_CD

      )

      USING INDEX XC404P0

      ENABLE;

       

      Is there a way to configure Oracle SQL Developer so that the Quick DDL or SQL tab will show CREATE UNIQUE INDEX and ALTER TABLE ADD CONSTRAINT PRIMARY KEY USING INDEX indexname?