ALTER TABLE table_name RENAME TO new_table_name;
ALTER TABLE your_table_name RENAME COLUMN original_column_name TO new_column_name;
ALTER TABLE table_name MODIFY column_name datatype;
ALTER TABLE contacts ADD last_name varchar(40) NOT NULL AFTER contact_id, ADD first_name varchar(35) NULL AFTER last_name;