There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key

by

Foreign keys work by joining a column to a unique key in another table, and that unique key must be defined as some form of unique index, be it the primary key, or some other unique index.

At the moment, the only unique index you have is a compound one on ISBN, Title which is your primary key.

There are a number of options open to you, depending on exactly what BookTitle holds and the relationship of the data within it.

I would hazard a guess that the ISBN is unique for each row in BookTitle. ON the assumption this is the case, then change your primary key to be only on ISBN, and change BookCopy so that instead of Title you have ISBN and join on that.

If you need to keep your primary key as ISBN, Title then you either need to store the ISBN in BookCopy as well as the Title, and foreign key on both columns, OR you need to create a unique index on BookTitle(Title) as a distinct index.

More generally, you need to make sure that the column or columns you have in your REFERENCES clause match exactly a unique index in the parent table: in your case it fails because you do not have a single unique index on Title alone.

More Related Contents:

  1. How do I make a composite key with SQL Server Management Studio?
  2. SQL where clause odd behavior [closed]
  3. SQL Server Exec issue [closed]
  4. Count(*) vs Count(1) – SQL Server
  5. How do I escape a single quote in SQL Server?
  6. NOT IN vs NOT EXISTS
  7. Simple way to transpose columns and rows in SQL?
  8. Only inserting a row if it’s not already there
  9. Unpivot with column name
  10. Selecting data from two different servers in SQL Server
  11. How to convert DateTime to VarChar
  12. Most efficient way in SQL Server to get date from date+time?
  13. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  14. Stored Procedure with optional “WHERE” parameters
  15. What’s the best way to capitalise the first letter of each word in a string in SQL Server
  16. SQL string comparison, greater than and less than operators
  17. Splitting the string in sql server
  18. How do I group on continuous ranges
  19. join comma delimited data column
  20. Need to list all triggers in SQL Server database with table name and table’s schema
  21. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  22. Get previous and next row from rows selected with (WHERE) conditions
  23. Does Sql JOIN order affect performance?
  24. Best equivalent for IsInteger in SQL Server
  25. How to list files inside a folder with SQL Server
  26. Using tuples in SQL “IN” clause
  27. Can SQL Server Express LocalDB be connected to remotely?
  28. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  29. COALESCE Function in TSQL
  30. Can’t create stored procedure with table output parameter

Leave a Comment