Hello everyone,
I have a form with fields sno, sname. I added a new field 'class' which is a list box with values 1 to 10.All the information related to sno, sname and class are stored in the student table.The class field has primary key.Now i want to drop the primary key which exists on this class field. So I executed "alter table student drop primary key(class);
It displayed an error message:ORA-01735:invalid alter table option. The reason why I want to drop this primary key is because when i try to open the legacy records on this form which do not have this new field does not allow me to save this form as this field has primary key constraint. If I can drop this constarint then I can update the student table with some default value in this class field for the legacy records as this field would be null for those records.Could any one let me know how to drop the primary key ?
Thanks,
Prathima
I have a form with fields sno, sname. I added a new field 'class' which is a list box with values 1 to 10.All the information related to sno, sname and class are stored in the student table.The class field has primary key.Now i want to drop the primary key which exists on this class field. So I executed "alter table student drop primary key(class);
It displayed an error message:ORA-01735:invalid alter table option. The reason why I want to drop this primary key is because when i try to open the legacy records on this form which do not have this new field does not allow me to save this form as this field has primary key constraint. If I can drop this constarint then I can update the student table with some default value in this class field for the legacy records as this field would be null for those records.Could any one let me know how to drop the primary key ?
Thanks,
Prathima