This documentation is for an older version. If you're using the most current version, select the documentation for that version with the version switch in the upper right corner of the online documentation, or by downloading a newer PDF or EPUB file.

INFORMATION_SCHEMA Index

C | I | K | P | R | S | T | U | V

C

[index top]

CHARACTER_SETS

Section 10.1.9.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 19.1, “The INFORMATION_SCHEMA CHARACTER_SETS Table”

COLLATION_CHARACTER_SET_APPLICABILITY

Section 19.3, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”

COLLATIONS

Section 20.6.5, “C API Data Structures”
Section 10.1.9.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 19.2, “The INFORMATION_SCHEMA COLLATIONS Table”

COLUMN_PRIVILEGES

Section 19.5, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

COLUMNS

Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 19.4, “The INFORMATION_SCHEMA COLUMNS Table”

I

[index top]

INFORMATION_SCHEMA.CHARACTER_SETS

Section A.11, “MySQL 5.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”

INFORMATION_SCHEMA.COLLATIONS

Section 10.4.2, “Choosing a Collation ID”

INFORMATION_SCHEMA.COLUMNS

Section A.11, “MySQL 5.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”

INFORMATION_SCHEMA.KEY_COLUMN_USAGE

Section 1.8.3.2, “FOREIGN KEY Constraints”
Section 14.2.3.4, “InnoDB and FOREIGN KEY Constraints”
Section 13.1.10.3, “Using FOREIGN KEY Constraints”

INFORMATION_SCHEMA.ROUTINES

Chapter 19, INFORMATION_SCHEMA Tables
Section A.4, “MySQL 5.0 FAQ: Stored Procedures and Functions”
Section 19.8, “The INFORMATION_SCHEMA ROUTINES Table”

INFORMATION_SCHEMA.TABLES

Chapter 19, INFORMATION_SCHEMA Tables

INFORMATION_SCHEMA.TRIGGERS

Section 2.19.1.1, “Changes Affecting Upgrades to 5.0”
Section A.5, “MySQL 5.0 FAQ: Triggers”

INFORMATION_SCHEMA.VIEWS

Section 18.4.3, “Updatable and Insertable Views”

K

[index top]

KEY_COLUMN_USAGE

Section 19.6, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”

P

[index top]

PROFILING

Section 13.7.5.28, “SHOW PROFILE Syntax”

R

[index top]

ROUTINES

Section A.4, “MySQL 5.0 FAQ: Stored Procedures and Functions”
Section 13.7.5.26, “SHOW PROCEDURE STATUS Syntax”
Section 18.2.3, “Stored Routine Metadata”
Section 19.8, “The INFORMATION_SCHEMA ROUTINES Table”

S

[index top]

SCHEMA_PRIVILEGES

Section 19.10, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”

SCHEMATA

Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 6.2.2, “Privilege System Grant Tables”
Section 19.9, “The INFORMATION_SCHEMA SCHEMATA Table”

STATISTICS

Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 19.11, “The INFORMATION_SCHEMA STATISTICS Table”

T

[index top]

TABLE_CONSTRAINTS

Section 19.13, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”

TABLE_PRIVILEGES

Section 19.14, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

TABLES

Section 14.7.2, “How to Use FEDERATED Tables”
Chapter 19, INFORMATION_SCHEMA Tables
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 19.12, “The INFORMATION_SCHEMA TABLES Table”

TRIGGERS

Section 13.7.5.35, “SHOW TRIGGERS Syntax”
Section 19.15, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 18.3.2, “Trigger Metadata”

U

[index top]

USER_PRIVILEGES

Section 19.16, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

V

[index top]

VIEWS

Section 13.7.5.10, “SHOW CREATE VIEW Syntax”
Section 19.17, “The INFORMATION_SCHEMA VIEWS Table”
Section 18.4.5, “View Metadata”