Can I add a column to an existing table?

ALTER command can add a new column to an existing table with a default value too. The default value is used when no value is inserted in the column. Following is the syntax, 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.
For More Information Please Refer:


You May Also Like to Read: