is there a tool that I can diagram out the relations in a database by drag dropping lines to columns but without actually creating foreign keys?
the diagrammer in sql managament studio ssms would be perfect except it creates keys in the database. I need to map out the relations for my understanding but i can't alter the database relations.
i want to point to existing database because i dont wnat to type all the columns again.
The database I'm using is a proprietary database that we use in house (PcmsDb), but we made an OLEDB driver for it and can also export the data or the metadata. And I have access to a Windows a Mac and a Linux box and a Chromebook that I can use if necessary to use the tool with. For a good enough tool we'll buy whatever OS we need to use it, it would be worth it. Anything is ok, but I prefer online tools, then windows, then ChromeOS, then Linux, then Mac, then whatever OS.
select Product, Features, ProductUrl, OS, Price, License where 1 = 1 order by price asc