• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 338
  • Last Modified:

cancel enforce relations

How can i cancel using MSSQL enterprise manager the enforce relations between tables?
0
eladr
Asked:
eladr
1 Solution
 
BillAn1Commented:
right click the child table in the relationship. Select "Design Table". Right Click again when in design mode, select "Realtionships". Unselect the "enforce relationship  for inserts and updates" option. This will disable the constraint.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now