INNODB_SYS_FOREIGN table provides status
foreign keys, equivalent
to the information from the
InnoDB data dictionary.
|The name (not a numeric value) of the foreign key index. Preceded by the
database name, for example,
|The name of the child table in this foreign key relationship.|
|The name of the parent table in this foreign key relationship.|
|The number of columns in the foreign key index.|
|A collection of bit flags with information about the foreign key column,
ORed together. 1 = |
You must have the
PROCESS privilege to
query this table.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices