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 |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2009-01-21 : 03:21:53
|
| Hi, I'm having Users, Tasks, and Categories:each user has many tasks each task may be in any or one category each user has many categoriesI want it when a user is deleted, his tasks and categories be deleted as well. and When a category is deleted the tasks that were in that category know that their in no category and when a task is deleted its category should not be deleted could you give me the design of tables and it primary and foreign keys as well as cascade properties?Thanks in advance |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-01-21 : 06:28:51
|
| Please do not cross post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=118269 |
 |
|
|
|
|
|
A DB Design question