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.

Note

Choosing No does not cancel the portion of the operation that has already been completed in the database.

See Also

Concepts

Error Messages in Visual Database Tools

Help and Information

Getting SQL Server 2005 Assistance