occurfscusync
New Member
I am running these two commands to create new tables, but the second create table command keeps giving me error. \[code\]CREATE TABLE TEAMSTADIUM(stadium_name varchar2(40) not null,stadium_max_capcity number(10) not null,stadium_field_serface varchar2(40) not null,stadium_year_built number(4) not null,stadium_location varchar2(40) not null,Primary KEY(stadium_name))CREATE TABLE TEAMINFO(team_name varchar2(40) not null,team_owner varchar2(40) not null,team_coach varchar2(40) not null,team_created Date() not null,PRIMARY KEY(team_name)foreign key(stadium_name) references TEAMSTADIUM(stadium_name))\[/code\]