Que: Which among the following is the correct syntax for modifying the definition of an existing table?

a. ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;
b. ALTER TABLE person person_id SMALLINT UNSIGNED AUTO_INCREMENT;
c. ALTER TABLE person MODIFY person_id ;
d. ALTER TABLE person
Answer: ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;

Leave a Comment