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;

What are the different tcl commands in sql?

0 Answers  

---

Why we use joins in sql?

0 Answers  

---

Why stored procedure is faster than query?

0 Answers  

---

What is mutating table?

11 Answers   Saama Tech,

---

Is sql a scripting language?

0 Answers  

---

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  

---

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  

---

What is pl/sql table? Why is it used?

0 Answers  

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

---

How do you drop a trigger?

0 Answers  

---

what is the difference between group by and order by in sql? : Sql dba

0 Answers  

---