Missing right parenthesis

Asked

Viewed 35 times

1

Creating the following table:

CREATE TABLE Corrida(
       Id NUMBER(6) PRIMARY KEY,
       BairroDaPartida CHAR(30),
       Valor NUMBER(5),
       Kms NUMBER(5),
       Prefixo CHAR(4),
       CPF NUMBER(8) FOREIGN KEY,
       CONSTRAINT FkCorridaPassageiro FOREIGN KEY (CPF) REFERENCES Passageiro,
);
sql
  • 1

    Remove the comma after the last command line. After Passenger.

  • CREATE TABLE Race( Id NUMBER(6) PRIMARY KEY, Bairrodadeparture CHAR(30), Value NUMBER(5), Kms NUMBER(5), Prefix CHAR(4), CPF NUMBER(8) FOREIGN KEY, CONSTRAINT Fkcorridapassenger FOREIGN KEY (CPF) REFERENCES Passenger );

No answers

Browser other questions tagged sql

You are not signed in. Login or sign up in order to post.