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 is the difference between sum and count in sql?

0 Answers  

---

Can variables be used in sql statements?

0 Answers  

---

i have some prob lem to tell me about my self in interview first round ...

0 Answers  

---

what is datawarehouse? : Sql dba

0 Answers  

---

How does sql*loader handles newline characters in a record? : aql loader

0 Answers  

---

How do I create a sql database?

0 Answers  

---

What is RAC in oracle?

7 Answers   MCN Solutions,

---

what are the t string functions available in tsql? : Transact sql

0 Answers  

---

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

---

Can we insert data in view?

0 Answers  

---

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

0 Answers  

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

0 Answers  

---