Home » SQL & PL/SQL » SQL & PL/SQL » Constraint Error
Constraint Error [message #2750] Sun, 11 August 2002 20:41 Go to next message
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 Go to previous messageGo to next message
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
Thanks [message #2794 is a reply to message #2755] Tue, 13 August 2002 20:39 Go to previous message
Diana
Messages: 17
Registered: February 1999
Junior Member
Thanks pk.
Previous Topic: read text file
Next Topic: how to use my variant in plsql?
Goto Forum:
  


Current Time: Fri Mar 29 05:51:52 CDT 2024