How to see foreign key view in navicat

There are three ways to view foreign key views in Navicat: direct access (find views starting with "FK_"), query the view (right-click "Query Data" from the view node), or expand INFORMATION_SCHEMA.KEY_COLUMN_USAGE table and use appropriate filters to identify foreign key references.

How to use Navicat to view foreign key views

Direct access

1. Connect to the database.
2. Expand the "View" node in the object tree.
3. Look for views starting with "FK_", which represent foreign key relationships.

Query View

1. Right-click the "View" node in the object tree.
2. Select "Query Data".
3. In the SQL Query Editor, enter the following query:

<code class="sql">SELECT
  *
FROM
  <view_name></code>

where <view_name> is the name of the foreign key view you want to view.

Expand INFORMATION_SCHEMA.KEY_COLUMN_USAGE Table

1. Expand the "System Table" node in the object tree.
2. Find and expand the INFORMATION_SCHEMA.KEY_COLUMN_USAGE table.
3. Use the following filter to view foreign key references:

• TABLE_NAME: The table where the foreign key resides
• CONSTRAINT_NAME : The name of the foreign key constraint
• REFERENCED_TABLE_NAME: The referenced table
• REFERENCED_COLUMN_NAME: The referenced column

Example

Suppose we have a table named Customers which contains a foreign key named customer_id which references # The order_id column in the ##Orders table.

To view the foreign key view, we can use the following steps:

1. Direct access: In the object tree, expand the "View" node and find the name View for FK_Customers_Orders.
2. Query View: Right-click the FK_Customers_Orders view and select "Query Data".
3. Expand INFORMATION_SCHEMA.KEY_COLUMN_USAGE Table: In the filter, specify TABLE_NAME as Customers, CONSTRAINT_NAME is FK_Customers_Orders, REFERENCED_TABLE_NAME is Orders, REFERENCED_COLUMN_NAME is order_id.

The above is the detailed content of How to see foreign key view in navicat. For more information, please follow other related articles on the PHP Chinese website!