Deleting Invoices

Jeffrey Betts ( (no email) )
Fri, 28 Feb 1997 12:34:50 -0800

I am trying to delete all existing invoices
and payments from the emerald database.
I picked up these commands from the list
a while back. They were from Dale.

TRUNCATE TABLE Invoiceitems
GO
TRUNCATE TABLE Payments
GO
TRUNCATE TABLE Invoices
GO

When I run these commands in ISQL/w I get the error

Msg 4712 Level 16, State 1
Cannot truncate table 'payments' because it is being referanced by a
foreign key constraint.

I get the same error for 'Invoices'

I have also tried
DELETE PAYMENTS
GO
DELETE INVOICES
GO

Can anyone give me the right commands to delete these records ?

Thanks

Jeff Betts
Jbetts@ccaccess.net