Dispaly Dependencies in SQL SERVER

• alice-243720

  SSC Veteran

  Points: 293

  More actions

  March 8, 2006 at 3:43 pm

  #168007

  I have two tables TSEmployee and TSHour in SQL Server DB.

  When I right click in TSHour table, I see TSEmployee table column in "objects that TSHour depends on". I understand that this table is depending on TSEmployee and that is why when ever an employee is deleted from TSEmployee all the records for this employee are deleted from TSHour. I want to keep the information in TSHour even after deleting the employee from TSEmployee. I beleive I can do that by removing this

  dependency. I am new to SQL Server, please let me know how to remove this dependency.

  Thanks!

• rakesh pundlikrao ambirwar-309087

  Valued Member

  Points: 55

  More actions

  March 10, 2006 at 2:40 am

  #625877

  Hi,

  If your TSHour table depends on TSEmployee table then you should not be able to delete the employee from TSEmployee because it depends on TSHour.

  If you try to delete the employee from TSEmployee it will give you error "The DELETE statement conflicted with the REFERENCE constraint...."

   

  Thanks

  Rakesh