Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-27 : 11:43:16
|
| Amol Suley writes "I have 2 different DB's. some tables in DB1 are views in DB2. My question is can i have constraints like foreign key relationships, created on views?Also can i create such constraints across DB's ?" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-12-27 : 15:12:40
|
| You need to use triggers for cross database DRI, these can be on tables or views. Have a look at CREATE TRIGGER in BOL.HTHJasper Smith |
 |
|
|
|
|
|
Views.