Adding a column to a table

Use the ALTER TABLE SQL statement to add a column to a table.

For example, to add a NOTES column to the CALENDAR table, run the following SQL statement:

ALTER TABLE CALENDAR
ADD NOTES VARCHAR(40)

In this statement, NOTES is the name of the new column, VARCHAR is the data type, and 40 is the number of characters in the column.

If the table is stored in a Db2® for z/OS® database, you can specify a default value other than null for the column. If the table is stored in a DB2® Server for VSE and VM database, the default value must be null for the column.