Triggers
alter trigger <TGR_NAME> disable;
alter trigger <TGR_NAME> enable;
Primary Key
alter table <TABLE_NAME> disable PRIMARY KEY;
alter table <TABLE_NAME> disable CONSTRAINT <PK_NAME>;
alter table <TABLE_NAME> enable PRIMARY KEY;
alter table <TABLE_NAME> enable CONSTRAINT <PK_NAME>;
Foreign Key
alter table <TABLE_NAME> disable CONSTRAINT <FK_NAME>;
alter table <TABLE_NAME> enable CONSTRAINT <FK_NAME>;
alter trigger <TGR_NAME> disable;
alter trigger <TGR_NAME> enable;
Primary Key
alter table <TABLE_NAME> disable PRIMARY KEY;
alter table <TABLE_NAME> disable CONSTRAINT <PK_NAME>;
alter table <TABLE_NAME> enable PRIMARY KEY;
alter table <TABLE_NAME> enable CONSTRAINT <PK_NAME>;
Foreign Key
alter table <TABLE_NAME> disable CONSTRAINT <FK_NAME>;
alter table <TABLE_NAME> enable CONSTRAINT <FK_NAME>;
0 comments:
Post a Comment