in my database i try to dele the old user .but i cant dellet them. the mssql say.
Error -2147217873
The DELETE statement conflicted with the REFERENCE constraint "FK_PrizeRescueRequest_User". The conflict occurred in database "DB_A1AD3A_test", table "dbo.PrizeRescueRequest", column 'user_id'.
DELETE FROM [DB_A1AD3A_test].[dbo].[User] WHERE 1=0 OR ( [id] = 16 )
but i cant delet the info in PrizeRescueRequest ...how do i emty PrizeRescueRequest content
without deleting the database