Last post Feb 18, 2016 06:51 AM by wmec
Feb 11, 2016 12:22 PM|mnmhemaj|LINK
If I create a SQL Database Diagram with tables related with Primary and Foreign key constraints, how will it affect the DML applied on the tables?
I have some stored procedures that update and delete the table data.
I want to know, if I create a SQL Database Diagram now , will it affect my stored procedures?
Feb 11, 2016 01:34 PM|PatriceSc|LINK
No, you can create a new diagram and show existing database objects on it without changing anything (apart creating the tables needed to store the diagram). Just don't use the diagram object editing features.
Feb 18, 2016 06:51 AM|wmec|LINK
1. Constraint will validate the integrity of the table, during data input.
2. Diagram would not affect Database SPs.