beebkhan (10/17/2012)
you need to find the table that is referencing the data in your rolemaster table and remove it before you remove it. otherwhilst you will have a lot of problems on your hands further down the line. You need to follow Atomicity rules ie remove all associated data before proceeding to truncate the table.
Hi
You don't have to delete the table referencing the rolemaster table data. You can modify its FK so that it takes some actions:
1. ON DELETE CASCADE (will delete the referencing rows)
2. ON DELETE SET NULL (FK must be nullable)
3. ON DELETE SET DEFAULT (the default value must be present in the parent table)
It's up to you what you want to do with the data in the table referencing rolemaster table data.
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com