For more details about ALTER TABLE and CREATE TABLE, see SQL Data Definition Language - Syntax and Examples, B035-1144.