Adding and updating columns

Adding columns to table

Let’s say we want to add a new text column nickName to the students table below.

SQL provides an ALTER TABLE statement, for making such updates to the structure of a table.

To add a column to a table, the ALTER TABLE statement can be used with an ADD COLUMN statement.

To add a column with constraints, we need to add the constraints along with the column description, similar to how a column constraint is specified in CREATE TABLE statements.