Modifying the data type of a column that already contains data can result in the permanent loss of data when the existing data is converted to the new type. In addition, code and applications that ...

Using default values on database columns helps to insulate database design issues from application code. Find out how to change a column's default value at a later date using a single command.