Changing the column to the selected data type will delete its indexes and all relationships it participates in. (Visual Database Tools)

The column whose data type you are changing participates in indexes or relationships or both. But the new data type you supplied cannot accommodate participation in indexes or relationships. If you proceed, the data type will change, but the existing indexes and relationships will be lost.

See Also

Concepts

Error Messages in Visual Database Tools

Help and Information

Getting SQL Server 2005 Assistance