Home » MYSQL » Alter Command » Question
  1. Which among the following is the correct syntax for modifying the definition of an existing table?
    1. ALTER TABLE person person_id SMALLINT UNSIGNED AUTO_INCREMENT;
    2. ALTER TABLE person
    3. ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;
    4. ALTER TABLE person MODIFY person_id ;
    5. None of these
Correct Option: C

ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;



Your comments will be displayed only after manual approval.