Q:

Table issue in SQL Server 2008

I have a table in SQL Server 2008 like this:
Column      DataType
-----------------------
FID         numeric(18, 0)
Name        varchar(50)
DOB         datetime
MobileNo    numeric(18, 0)
EmailId     varchar(50)
add1        varchar(50)
add2        varchar(50)
add3        varchar(50)
Pincode     numeric(18, 0)
UpdateDate  datetime

In this table FID should be changed to varchar(50) without dropping (deleting) the table..
How to do this and also FID is set as primary key to the above table and also as a foreign key to other tables

A:

Tools->Options->designers->(Unmark)Prevent saving changes that require table recreation

