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 |
|
blocker
Yak Posting Veteran
89 Posts |
 Posted - 2010-03-22 : 21:04:28
|
| Good day.I just want to ask on how to achieve a full boost data integrity structure in sql server.Thank you for your ideas. God bless. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
blocker
Yak Posting Veteran
89 Posts |
Posted - 2010-03-23 : 00:43:16
|
| An intity/table design that will update all related data when it is changed/modified. Ex. if the product name was changed in table_1 all product names in table_2 and so on with the same productid will automaticaly updated. Another example is, when the product has other invoices pending, sql server will prevent it from being deleted.. This is called data integrity. My question is how to achieve this structure/flow?Thank you for the idea. God bless. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
blocker
Yak Posting Veteran
89 Posts |
Posted - 2010-03-23 : 21:05:33
|
| i have succesfully set-up the primary key in the main table and foreign keys on the child table. but i do not know what do you mean about cascade option.? Is there anything i need to set-up on my main table and child tables aside from primary keys & foreign keys.?Thank you for the ideas. God bless. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-24 : 04:26:37
|
" what do you mean about cascade option. "FOREIGN KEY (SalesPersonID) REFERENCES SalesPerson(SalesPersonID) ON UPDATE CASCADE |
|
|
|
blocker
Yak Posting Veteran
89 Posts |
Posted - 2010-03-24 : 04:40:49
|
| thank you.. this helps m a lot..God bless us all. |
|
|
|
|
|
|
Data Integrity Management..