Changing the column to the selected data type will delete relationships. (Visual Database Tools)
The columns whose data types you are changing participate in foreign-key relationships. If the data types are changed, the relationships will be deleted. Choose Yes to proceed with the operation and delete the relationships. Choose No to stop the operation.
Choosing No does not cancel the portion of the operation that has already been completed in the database.