and many other tables. The tables did not have any lookup table
relationships which I am adding. One lookup table is used for same data
in several different places.
To use one lookup tables with several tables, I had to disable "Cascade
Update" and only have "enforce relationships for updates and inserts"
checked.
Any pros/cons?
Thanks in advance.
P"Lookup table" doesn't mean anything in a relational database. There is only
one type of table.
You define relationships between tables with a foreign key. Unfortunately
SQL Server will only allow cascaded updates and deletes on one key per
table. However, in many cases cascaded updates are undesirable and since
it's fairly easy to code the same you probably won't miss this feature most
of the time.
--
David Portas
SQL Server MVP
--
No comments:
Post a Comment