can we have a foreign key which is not a primary key in any other table?

by

Yes – you can have a foreign key that references a unique index in another table.

CREATE UNIQUE INDEX UX01_YourTable ON dbo.YourTable(SomeUniqueColumn)

ALTER TABLE dbo.YourChildTable
   ADD CONSTRAINT FK_ChildTable_Table
   FOREIGN KEY(YourFKColumn) REFERENCES dbo.YourTable(SomeUniqueColumn)

More Related Contents:

  1. Is there a severe performance hit for using Foreign Keys in SQL Server?
  2. how to create this table in sql server?
  3. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  4. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  5. What is the purpose of system table master..spt_values and what are the meanings of its values?
  6. How to create multiple one to one’s
  7. SQL – How to store and navigate hierarchies?
  8. Can a foreign key be NULL and/or duplicate?
  9. Add Foreign Key relationship between two Databases
  10. Does Foreign Key improve query performance?
  11. Why (and how) to split column using master..spt_values?
  12. SQL Server: Howto get foreign key reference from information_schema?
  13. How can I INSERT data into two tables simultaneously in SQL Server?
  14. Should I design a table with a primary key of varchar or int?
  15. Composite Primary key vs additional “ID” column?
  16. MS SQL “ON DELETE CASCADE” multiple foreign keys pointing to the same table?
  17. Can I set ignore_dup_key on for a primary key?
  18. Should I use SQL_Variant data type?
  19. What does ON [PRIMARY] mean?
  20. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  21. Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
  22. Single or multiple databases
  23. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  24. Update records in table from CTE
  25. single fixed table with multiple columns vs flexible abstract tables
  26. How to insert multiple records and get the identity value?
  27. How can a LEFT OUTER JOIN return more records than exist in the left table?
  28. How to replace (null) values with 0 output in PIVOT
  29. Safest way to get last record ID from a table
  30. Space used by nulls in database

Leave a Comment