Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
The INNODB_SYS_FOREIGN table provides status information about InnoDB foreign
keys, equivalent to the information from the SYS_FOREIGN table in the InnoDB data dictionary.
Table 19.11. INNODB_SYS_FOREIGN Columns
| Column name | Description |
|---|---|
ID |
The name (not a numeric value) of the foreign key index. Preceded by the database name, for
example, test/products_fk.
|
FOR_NAME |
The name of the child table in this foreign key relationship. |
REF_NAME |
The name of the parent table in this foreign key relationship. |
N_COLS |
The number of columns in the foreign key index. |
TYPE |
A collection of bit flags with information about the foreign key column, ORed together. 1 =
ON DELETE CASCADE, 2 = ON UPDATE SET
NULL, 4 = ON UPDATE CASCADE, 8 = ON UPDATE
SET NULL, 16 = ON DELETE NOACTION, 32 = ON UPDATE NO ACTION.
|
Notes:
Since the INFORMATION_SCHEMA is a general-purpose way
to monitor the MySQL server, use this table rather than the corresponding InnoDB system table for any new monitoring application you develop.
You must have the PROCESS privilege to query this
table.