Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Table Design
practice_id(doctor_id), name, address, gender. Practice_id(doctor_id) is primary key. Now I want to alter table to add a new column specialization.But when I query.........
ALTER TABLE Practice ADD specialization char(12)
The error occurs. I knows that the error occurs because of PRIMARY KEY attribute of practice_id(doctor_id).
Now,the one and fool way is that first I drop the PRIMARY KEY constraint, then I TRUNCATE the table and then at last ADD specialization column(entity).
This way is not well to follow. Now please guide me how I add an entity [specialization] without doing this above foolish job.