Alter (SQL)

From Wikipedia, the free encyclopedia

An ALTER statement in SQL changes the properties of an object inside of a relational database management system (RDBMS). The types of objects that can be altered depends on which RDBMS is being used.

The typical usage is ALTER objecttype objectname parameters. For example, the command to add a column named bubbles to an existing table named sink would be: ALTER TABLE sink ADD COLUMN bubbles INTEGER;