Changes

A pre-existing table in a database may be modified using the SQL ''ALTER TABLE'' statement. The ''ALTER TABLE'' statement allows changes to the structure of a table to be modified. Permitted changes include the addition or removal of columns, changing the data type of a column and renaming of the table or columns. The ''CREATE TABLE'' syntax requires the name of the table to be altered, followed by the list of changes that are to made to the table: ALTER TABLE ''table_name'' ''alteration_spec'', ''alteration_spec'', ....