Cannot Find Table or Constraint

[whatdoido]

I'm suppose to make a table called MOVSTARDIR, and am suppose to have mvnum, starnum, and dirnum as primary keys with referential integrity enforced but I keep getting Cannt find table or constraint

CREATE TABLE MOVSTARDIR
(
MVNUM SHORT NOT NULL,
STARNUM SHORT NOT NULL,
DIRNUM SHORT NOT NULL,
BESTM INT,
BESTF INT,
SUPM INT,
SUPF INT,
PRIMARY KEY (mvnum, starnum, dirnum),
FOREIGN KEY (mvnum) REFERENCES MOVIE,
FOREIGN KEY (starnum) REFERENCES STAR,
FOREIGN KEY (dirnum) REFERENCES DIRECTOR
);

[Rabbit]

The error is a fairly clear one. You are trying to reference a table that doesn't exists. You do not have one or more of the following tables: MOVIE, STAR, DIRECTOR. Those tables need to be created first if you're going to reference them.

[NeoPa]

It appears clear this is a SQL Server (or T-SQL) question, so I've moved it to that forum for you.

[SimMed]

@Rabbit is right, do you have these tables you are referring to?