Can I add a new column with preset default value?

The above command will add a new column with a preset default value to the table student. ALTER command can also be used to modify data type of any existing column. Following is the syntax, Remember we added a new column address in the beginning?
For More Information Please Refer:

You May Also Like to Read: