How to drop a column level constraint?

I cant drop the whole column because that is interlinked with my process? I have declared not null on a column, I have to change it

Interview Candidate
Nov 21st, 2007
3
2212

SQL

Answer

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

kishore.giri
Profile Answers by kishore.giri Questions by kishore.giri

Dec 10th, 2007

Dear Sarika,
Instead dropping the constraint just disable the constarint.
The command is:

Alter table table_name disable constraint constraint_name;

try it and reply me