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.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…