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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 how to force delete referenced field?

Author  Topic 

cristuballa
Starting Member

13 Posts

Posted - 2003-11-21 : 04:19:06
how to force delete referenced field?
I have two tables field (ID)is the primary key to the first table and is foreign key to the second table and my problem is i cannot delete record on the first table when it has referenced record from the second table.



mr_mist
Grunnio

1870 Posts

Posted - 2003-11-21 : 04:21:31
You will have to either drop the constraint, or delete them in the proper order.

-------
Moo. :)
Go to Top of Page

cristuballa
Starting Member

13 Posts

Posted - 2003-11-21 : 04:34:19
thanx mr mist
Go to Top of Page
   

- Advertisement -