How do I create a foreign key in SQL Server?

by

And if you just want to create the constraint on its own, you can use ALTER TABLE

alter table MyTable
add constraint MyTable_MyColumn_FK FOREIGN KEY ( MyColumn ) references MyOtherTable(PKColumn)

I wouldn’t recommend the syntax mentioned by Sara Chipps for inline creation, just because I would rather name my own constraints.

More Related Contents:

  1. Subquery using Exists 1 or Exists *
  2. Truncate (not round) decimal places in SQL Server
  3. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  4. Select statement to find duplicates on certain fields
  5. Getting only Month and Year from SQL DATE
  6. Update records in table from CTE
  7. Dynamic Pivot Columns in SQL Server
  8. WHERE Clause vs ON when using JOIN
  9. Is it possible to select sql server data using column ordinal position
  10. Selecting N rows in SQL Server
  11. how can I Update top 100 records in sql server
  12. How to send email from SQL Server?
  13. How To Create Table with Identity Column
  14. Why do you create a View in a database?
  15. SQL query to find Nth highest salary from a salary table
  16. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  17. Calculate the number of records for each date between 2 dates
  18. T-SQL: How to use parameters in dynamic SQL?
  19. Get the records of last month in SQL server
  20. How to compare datetime with only date in SQL Server
  21. Merge overlapping date intervals
  22. SQL server select distinct rows using most recent value only
  23. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  24. alternatives to REPLACE on a text or ntext datatype
  25. Split words with a capital letter in sql
  26. SQL poor stored procedure execution plan performance – parameter sniffing
  27. Eliminate and reduce overlapping date ranges
  28. scope_identity vs ident_current
  29. COALESCE Function in TSQL
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment