ronipats
asked on
sql server 2008, stored procedure
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.
i.e.
degreeid int(identity)PK
degreetype varchar(50)
degreename varchar(50).
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.
thanks
ronak
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.
i.e.
degreeid int(identity)PK
degreetype varchar(50)
degreename varchar(50).
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.
thanks
ronak
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Go into Tools -> Options -> Designers-> Uncheck "Prevent saving changes that require table re-creation"