Forum Stats

  • 3,875,295 Users
  • 2,266,907 Discussions
  • 7,912,141 Comments

Discussions

Missing right parenthesis sql plus

1004689
1004689 Member Posts: 2
edited Jun 19, 2013 4:48AM in PHP
Hi, trying to create this table but *'Missing right parenthesis'* on the 16th line, which starts FOREIGN KEY comes up, I don't know where I'm going wrong. Help PLEASE!


CREATE TABLE player_performance
(
player_performance_id numeric(10)NOT NULL,
player_id numeric(10) NOT NULL,
match_id numeric(10) NOT NULL,
two_points_attempts integer,
two_points_made integer,
three_points_attempts integer,
three_points_made integer,
free_throw_attempts integer,
free_throws_made integer,
minutes_played integer,
fouls_made integer,
rebounds integer,
CONSTRAINT player_performance_PK PRIMARY KEY (player_performance_id)
FOREIGN KEY (player_id) REFERENCES player (player_id);
);

Answers

This discussion has been closed.