Ibm Data Studio
This tutorial will show you how to discover foreign keys and related tables using IBM Data Studio.
Before starting, make sure you have selected the Administer Databases in the Activity button.
Data Studio overview. IBM Data Studio is a graphical development tool that is based on the Eclipse technology. Data Studio supports a wide variety of features for the application developer from browsing and editing data in tables to creating and running SQL statements. Article for: IBM Data Studio SQL Server Management Studio (SSMS) MySQL Workbench Oracle SQL Developer DataGrip Toad for Oracle Toad for SQL Server This tutorial will show you how to create a diagram for an existing DB2 database using IBM Data Studio.
There are two options you can do it.
Option 1: Administration Explorer
Ibm Data Studio Tutorial
- In Administration Explorer expand the All Databases node and select the appropriate database to expand its objects tree, then select Constraints.
- The upper right pane shows the list of all constraints in the selected database. You can click on the Type column to sort by type, so you can easily find all the foreign keys.
Ibm Data Studio For Db2
Option 2: Using the Pictorial Path
Install Ibm Data Studio
- In the upper right pane, click on the last icon of the pictorial path to display the list of options, then select Constraints.
Ibm Data Studio Export To Csv
- As in the previous section, the upper right pane shows the list of all the constraints in the selected database and you can click on the Type column to sort by name, so you can easily see all the foreign keys.