Discuss in Forum
All of above
ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;
The ‘ALTER TABLE’ statement is used to make changes to a database’s global attributes. This statement is followed by the name of the database, character set and collation.