every time I want to create this table, it says Missing Right Parenthesis. Can someone please check what i have wrong please. Thank you
CREATE TABLE Pet
(
PetID Int NOT NULL PRIMARY KEY,
OwnerID Char (7) NOT NULL,
TypeID Char integer NOT NULL,
PetName Char (30),
Description Char (50),
Birthday VarChar (255),
LastVisit VarChar (255)
);
CREATE TABLE Pet
(
PetID Int NOT NULL PRIMARY KEY,
OwnerID Char (7) NOT NULL,
TypeID Char NOT NULL,
PetName Char (30),
Description Char (50),
Birthday VarChar (255),
LastVisit VarChar (255)
);
Check this column data type Char Or Integer - TypeID