In Sql Which Of The Following Statement Can Be Used To Apply #403
In SQL, which of the following statement can be used to apply the AUTO INCREMENT field on a column?
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.
In SQL, which of the following statement can be used to apply the AUTO INCREMENT field on a column?
CREATE TABLE table_name AUTO_INCREMENT ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint);
CREATE TABLE table_name ( column1 datatype constraint AUTOINCREMENT, column2 datatype constraint, ... columnn datatype constraint);
CREATE TABLE table_name ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint, AUTO_INCREMENT (column_name));
CREATE TABLE table_name ( column1 datatype constraint AUTO_INCREMENT, column2 datatype constraint, …. columnn datatype constraint);