Can I have a foreign key referencing a column in a view in SQL Server?

by

You can’t reference a view in a foreign key.

More Related Contents:

  1. How can foreign key constraints be temporarily disabled using T-SQL?
  2. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  3. Create a view with ORDER BY clause
  4. When/Why to use Cascading in SQL Server?
  5. How to update primary key
  6. TSQL: Create a view that accesses multiple databases
  7. Local and global temporary tables in SQL Server
  8. Get first day of week in SQL Server
  9. Can a foreign key be NULL and/or duplicate?
  10. SQL Server add auto increment primary key to existing table
  11. SQL Server: UPDATE a table by using ORDER BY
  12. EF5: Cannot attach the file ‘{0}’ as database ‘{1}’
  13. SQL Server: How to select all days in a date range even if no data exists for some days
  14. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  15. Do while loop in SQL Server 2008
  16. TSQL: How to convert local time to UTC? (SQL Server 2008)
  17. Transpose rows and columns with no aggregate
  18. How do I pass value to a stored procedure parameter in OLE DB Source component?
  19. How can I import an Excel file into SQL Server? [closed]
  20. Possible to set default schema from connection string?
  21. How does sql server choose values in an update statement where there are multiple options?
  22. Entity Framework Core 2.0: How to configure abstract base class once
  23. WHERE clause better execute before IN and JOIN or after
  24. How to reuse calculated columns avoiding duplicating the sql statement
  25. Commas within CSV Data
  26. How do I move a table into a schema in T-SQL
  27. nvarchar(max) vs NText
  28. How to use RANK() in SQL Server
  29. Unable to find the requested .Net Framework Data Provider. It may not be installed. – when following mvc3 asp.net tutorial
  30. SQL Server error “Implicit conversion of because the collation of the value is unresolved due to a collation conflict.”

Leave a Comment