INNODB_SYS_FOREIGN_COLS table provides
status information about the columns of
foreign keys, equivalent to the information from the
SYS_FOREIGN_COLS table in the
InnoDB data dictionary.
|The foreign key index associated with this index key field, using the
same value as |
|The name of the associated column in the child table.|
|The name of the associated column in the parent table.|
|The ordinal position of this key field within the foreign key index, starting from 0.|
You must have the
PROCESS privilege to
query this table.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices