Reference Manual

10.5.4
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

DTLDESCRIBE FKEYS Foreign Keys Information Retrieval

Example 1:

Given a table, find all the foreign keys defined on that table.

Table MFERNANDEZ.T2 has two foreign keys.

(FK21) to T1 from column T21 to T11 with UPDATE rule RESTRICT and DELETE rule = DELETE

and

(FK23) to T3 from columns T22,T23 to T31,T32 with UPDATE rule NOACTION and DELETE rule = NOACTION

DTLDESCRIBE fkeys,,,,mfernandez,,t2

Example 1 Result:

MFERNANDEZ||T1|T11|MFERNANDEZ||T2|T21|1|RESTRICT|RESTRICT|FK21|SQL010827171053710|
MFERNANDEZ||T3|T31|MFERNANDEZ||T2|T22|1|NO ACTION|NO ACTION|FK23|PK3|
MFERNANDEZ||T3|T32|MFERNANDEZ||T2|T23|2|NO ACTION|NO ACTION|FK23|PK3|

Example 2:

Given a "parent table", find all the foreign keys that point to that table

DTLDESCRIBE fkeys,mfernandez,,t1

Example 2 Result:

MFERNANDEZ||T1|T11|MFERNANDEZ||T2|T21|1|RESTRICT|RESTRICT|FK21|SQL010827171053710|

It is valid to query on both the parent and the foreign tables as shown below.

DTLDESCRIBE fkeys,mfernandez,,t*,mfernandez,,q*

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

DTLDESCRIBE FKEYS Foreign Keys Information Retrieval

DTLDESCRIBE FKEYS Foreign Keys Information Retrieval