Constraint Error [message #2750] |
Sun, 11 August 2002 20:41 |
Diana
Messages: 17 Registered: February 1999
|
Junior Member |
|
|
Hello,
I have accidentally specified a constraint when I shouldn't have. It goes as follows:
ALTER TABLE STUDENT ADD PERMPHONE VARCHAR2(10) CONSTRAINT STUDENT_PERMPHONE_NN NOT NULL;
How do I disable this constraint?
I tried ALTER TABLE STUDENT MODIFY PERMPHONE VARCHAR2(10); and I checked the table USER_CONSTRAINTS but I'm not certain it's done the trick.
Thanks,
Diana
|
|
|
Re: Constraint Error [message #2755 is a reply to message #2750] |
Mon, 12 August 2002 02:26 |
pk
Messages: 12 Registered: September 2000
|
Junior Member |
|
|
Try this ....
SQL> alter table student
2 drop constraint STUDENT_PERMPHONE_NN;
Table altered.
SQL> desc student;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(10)
PERMPHONE VARCHAR2(10)
SQL> ED
Wrote file afiedt.buf
1* select CONSTRAINT_name from user_constraints where table_name='STUDENT'
SQL> /
no rows selected
|
|
|
|