Can I add a new column with preset default value?

[Dhiya]

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:

Alter Query DDL command in SQL | Studytonight

You May Also Like to Read:

How do I drop a column from a table?

to drop a column from the table. Using ALTER command we can add a column to any existing table. Following is the syntax, The above command will add a new column address to the table student, which will hold data of type varchar which is nothing but string, of length 200. For More Information Please Refer: You May Also Like to Read: