create table table_book_authors (
AuthorID int primary key not null identity (1,1),
BookID int not null constraint fk_book_BookID foreign key references table_book(book_BookID) ON UPDATE CASCADE ON DELETE CASCADE,
AuthorName varchar(50) not null
);
Foreign key ‘fk_book_BookID’ references invalid column ‘book_BookID’ in referenced table ‘table_book’.
New contributor
Tahsin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.