TRUNCATE TABLE Invoiceitems
TRUNCATE TABLE Payments
TRUNCATE TABLE Invoices
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
Can anyone give me the right commands to delete these records ?