테이블 기본키 인덱스명 설정

create table tb_ip_XXXX

(   IPS                                  VARCHAR(15)     FIXED   NOT NULL ,

    IPE                                      VARCHAR(15)     FIXED   NOT NULL ,

    INTIPS                                   BIGINT          FIXED   NOT NULL ,

    INTIPE                                   BIGINT          FIXED   NOT NULL ,

    CONSTRAINT TB_IP_XXXX_IDX_PR1 PRIMARY KEY (IPS,IPE)

);  CREATE INDEX tb_ip_XXXX_idx1 ON tb_ip_XXXX(INTIPS,INTIPE)

CREATE UNIQUE INDEX PK_USER_MENU ON TB_USER_MENU(USER_GRP_CD, MENU_ID) TABLESPACE KTIDP_IDX;