ALTER TABLE C##AD.AD_PRINTFORMAT_TRL
DROP PRIMARY KEY CASCADE;
DROP TABLE C##AD.AD_PRINTFORMAT_TRL CASCADE CONSTRAINTS;
CREATE TABLE C##AD.AD_PRINTFORMAT_TRL
(
AD_PRINTFORMAT_ID NUMBER(10) DEFAULT 0 NOT NULL,
AD_LANGUAGE VARCHAR2(6 BYTE) NOT NULL,
CREATE UNIQUE INDEX C##AD.AD_PRINTFORMAT_TRL_KEY ON C##AD.AD_PRINTFORMAT_TRL
(AD_PRINTFORMAT_ID,AD_LANGUAGE)
ALTER TABLE C##AD.AD_PRINTFORMAT_TRL ADD (
CONSTRAINT AD_PRINTFORMAT_TRL_KEY
PRIMARY KEY
(AD_PRINTFORMAT_ID,AD_LANGUAGE))
沒有留言:
張貼留言