Which Of The Following Statement Is Used To Change The Default #406
Which of the following statement is used to change the default value of the AUTO INCREMENT field?
This multiple choice question (MCQ) is related to the book/course gs gs115 Structured Query Language. It can also be found in gs gs115 SQL Constraints - SQL Auto Increment - Quiz No.1.
Which of the following statement is used to change the default value of the AUTO INCREMENT field?
ALTER table_name AUTO_INCREMENT=100;
ALTER TABLE table_name AUTO_INCREMENT=100;
CHANGE TABLE table_name AUTO_INCREMENT=100;
ALTER TABLE table_name AUTO_INCREMENT (100);