In visual studio datasource designer is there any way to refresh a table and its relations/foreign key constraints while keeping the custom queries? The way I am doing it at the moment is removing...

I've got a DataSet in VisualStudio 2005. I need to change the datatype of a column in one of the datatables from System.Int32 to System.Decimal. When I try to change the datatype in the DataSet Des...