add a column to a table in SQL

ALTER TABLE person
ADD AddressId int

 
 

...the following will turn around and throw the new column away again:

ALTER TABLE person
DROP COLUMN AddressId