How to refresh contents of a child table...
I have three tables in my Movies database: Titles, Actors, and Movies.
In my join table, Movies, I created two foreign keys, one linked to the field Title in Titles, and one linked to the field Name in Actors.
Here's the code...
create table Titles (
Title varchar(50) primary key,
Genre varchar(15) not null,
Actor varchar(30)
);
create table Actors (
Name varchar(30) primary key,
Movie varchar(50),
);
create table Movies (
Title varchar(50) references Titles(Title),
Genre varchar(15) references Titles(Genre),
ActorName varchar(30) references Actors(Name)
);
After filling the two parent tables, Titles and Actors, I notice that the child table, Movies, has not updated, despite the relationships. Is there a special command I must use to refresh my Movies table?
Thanks.