Question: The following CREATE TABLE statement creates a table called 'artist' that consists of the artist _ id as the primary key that is auto -
The following CREATE TABLE statement creates a table called 'artist' that consists of the artistid as the primary key that is autoincremented, the firstname, and the lastname.
CREATE TABLE artists
artistid serial INT,
firstname VARCHAR
lastname VARCHAR
;
Identify the line of code that would either generate a syntax, logical or requirements error in this CREATE TABLE statement.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
