I want to find which tables are related to a specific table. I can see all the foreign key constraints easily enough, but what about table for which the table I am looking at is the primary key table and the other table is the referenced table.
How can I display the relationship names in the diagram? It's a 'Show' option. The relationship names are referred to as 'labels' in SQL Developer. So right click in the model, go to 'Show' and toggle on 'Labels.
You can actually see the queries that SQL Developer runs under the hood. If you go to to the View menu and choose Log, or hit Ctrl Shift L (assuming you're using Windows) you'll get a docked window which by default is titled "Messages - Log". At the bottom of that are two tabs, with "Messages" selected.
A: Yes. ApexSQL Compare offers integration for SSMS and Visual Studio, so you can right-click a SQL object in Object Explorer, select the Compare scripts in the right-click context menu, then Set as left/right, and the New comparison query window will be shown.
Steps in SQL Developer
View
> Data Modeler
> Browser
to open up the Browser
view/tab. Browser
view/tab*) right click on Relational Models
and select New Relational Model
which opens up a new window. This should create a new blank diagram which one can drag and drop tables from the Connections
view into the diagram.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With