how can truncate foreign key table in sql withough deleting main table data

    Msg 547, Level 16, State 0, Line 1 The DELETE statement conflicted with the REFERENCE constraint “FK__tblLivePr__PBran__681373AD”. The conflict occurred in database “LoginDB”, table “dbo.tblLiveProducts”, column ‘PBrandId’. The statement has been terminated. Checking identity information: current identity value ‘1’, current column value ‘1’. DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    yks Asked on January 16, 2016 in No Category.
    Add Comment
  • 0 Answer(s)

    Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.