New answers tagged


You could programmatically build queries to test which combinations of columns look like they might be keys. In order to test a given relationship you'd run a query of the form: SELECT 1 AS [IsPossibleKey: ChildTable.KeyColumn => ParentTable.PrimaryKeyColumn] WHERE NOT EXISTS ( SELECT * FROM ChildTable c WHERE NOT EXISTS ( SELECT * FROM ...


I don't have enough rep to post a comment but wanted to help with your question about getting the SQL Power Doc to work. If you follow the steps on their documentation page it will work pretty easily. Just start from the top.

Top 50 recent answers are included