WHICH_AMONG_THE_FOLLOWING_IS_THE_CORRECT_SYNTAX_FOR_MODIFYING_THE_DEFINITION_OF_AN_EXISTING_TABLE??$

Question

TuteeHUB · Accepted Answer

ALTER TABLE person MODIFY person_id ;

TuteeHUB · Answer

ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;

TuteeHUB · Answer

ALTER TABLE person person_id SMALLINT UNSIGNED AUTO_INCREMENT;

TuteeHUB · Answer

ALTER TABLE person

1.	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» C. ALTER TABLE person MODIFY person_id ;

Discussion