Answer / muralidhar v

To Activate any integrity constraint, use Enable command
with Alter and to deactivate use disable with Alter.

To drop any constraint other than NOT NULL, use Drop
command with Alter. We can't drop not null, but we can
change it to NULL with Alter --Modify option.

Answer / j

Alter table table_name ENABLE constraint constraint_name;

Alter table table_name DISABLE constraint constraint_name;

How do you create a db file?

0 Answers  

---

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

---

Is it possible to create startup or shutdown trigger for on-schema?

0 Answers  

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

0 Answers  

---

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

---

how to get a list of indexes of an existing table? : Sql dba

0 Answers  

---

What is cross join sql?

0 Answers  

---

How to recompile a already made trigger?

2 Answers  

---

what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,

---

Is sql a programming?

0 Answers  

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---

What version is sql?

0 Answers  

---