my member master table have a field called memberID which is referenced key to many tables. when i try to delete a record from membermaster table it shows error of reference key.
i want to know command or option which can be added in the table to ignore the reference key for deletion.



thanks......

__________________
thanks......

You can't. This is what relational data is all about. If you deleted the member master record, you would then have records in related tables that reference a value that no longer exists.

Well, i said you can't, but if you make some changes you can. You can change the relationship to include CASCADE DELETE (you'll have to drop and recreate the relationship between the member master table and the other related tables). This will let you delete the record from the member master table, but then it will also delete all reldated records in referened tables.

You can do that, or, you can remove the relationships all togehter (I WOULD NOT RECOMMEND THIS).

Again, this is what relational databases is all about. Keep the integrity of the data clean.

Hope this helps...

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html