In general, though, significant changes to the data type and length of a column usually require the table to be dropped and recreated with the new data type and length. When making changes to a ...