sir i have created one table (degree master) as below in sql server 2008
degreeid int(identity) PK
degree name varchar(50)
i have few records of data in this table and this table has relationship with two more table (program master and faculty master).
now i want to add a new field to this degree master table after degreeid field.
after adding this field when i try to save this table it gives me error and suggest to drop and re-create table again. I also tried it after removing relationship with other two table but still it gives me the same error and suggest me to drop and create table again which i dont want to do.
Is there any other ways to do so.