Finding Table and Primary Key and Foreign Key

Rédigé par M Sozezzo - - Aucun commentaire

SQL Server does not help to easily determine the dependencies between tables.
This research presents the parent table and the child tables and columns used.

 

https://msdn.microsoft.com/en-us/library/ms179610.aspx
http://stackoverflow.com/questions/925738/how-to-find-foreign-key-dependencies-in-sql-server
 

well, however, we have many databases with bad design that didn’t have foreign keys defined but that did have related data.

Lire la suite de Finding Table and Primary Key and Foreign Key

Fil RSS des articles de ce mot clé