I did exactly what the expert answer said to do and when i tried to save it the

Question

I did exactly what the expert answer said to do and when i tried to save it the message Syntax error in create Table statement. can you please tell me what i'm doing wrong? The question in, Write a SQL Create Table statement to create the Pet_Owner table, with OwnerID asa surrogate key. Save as CreatePetOwner. This is my anwer using Microsoft Access 2016: CREATE TABLE PET_OWNER ( OwnerID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, OwnerLastName varchar(50) , OwnerFirstName varchar(50) , OwnerPhone varchar(15) , OwnerEmail varchar(255) ); Once I get ready to save it,or run it, the message Syntax error in CREATE TABLE statement. Can you please tell me what I'm doing wrong?

Explanation / Answer

CREATE TABLE PET_OWNER ( OwnerID INT NOT NULL AUTO_INCREMENT, OwnerLastName varchar(50) , OwnerFirstName varchar(50) , OwnerPhone varchar(15) , OwnerEmail varchar(255) ,PRIMARY KEY OwnerID);

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.