9 lines
548 B
SQL
9 lines
548 B
SQL
--------------------------------------------------------
|
|
-- Constraints for Table TMP_ENVIROMENT_PATTERN
|
|
--------------------------------------------------------
|
|
|
|
ALTER TABLE "ENVX_OPER"."TMP_ENVIROMENT_PATTERN" ADD CONSTRAINT "TMP_ENVIROMENT_PATTERN_PK" PRIMARY KEY ("ID_PATTERN", "ID_ENVIROMENT")
|
|
USING INDEX "ENVX_OPER"."TMP_ENVIROMENT_PATTERN_PK" ENABLE;
|
|
ALTER TABLE "ENVX_OPER"."TMP_ENVIROMENT_PATTERN" MODIFY ("ID_ENVIROMENT" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."TMP_ENVIROMENT_PATTERN" MODIFY ("ID_PATTERN" NOT NULL ENABLE);
|