![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461961740.webp)
The
INFORMATION_SCHEMA KEY_COLUMN_USAGE
Table
1720
• In the output from
SHOW FULL COLUMNS
, the privileges are all in one field and in lowercase, for
example,
select,insert,update,references
. In
COLUMN_PRIVILEGES
, there is one privilege
per row, in uppercase.
•
PRIVILEGE_TYPE
can contain one (and only one) of these values:
SELECT
[578]
,
INSERT
[577]
,
UPDATE
[578]
,
REFERENCES
[577]
.
• If the user has
GRANT OPTION
[577]
privilege,
IS_GRANTABLE
should be
YES
. Otherwise,
IS_GRANTABLE
should be
NO
. The output does not list
GRANT OPTION
[577]
as a separate
privilege.
The following statements are not equivalent:
SELECT ... FROM INFORMATION_SCHEMA.COLUMN_PRIVILEGES
SHOW GRANTS ...
19.6. The
INFORMATION_SCHEMA KEY_COLUMN_USAGE
Table
The
KEY_COLUMN_USAGE
table describes which key columns have constraints.
INFORMATION_SCHEMA
Name
SHOW
Name
Remarks
CONSTRAINT_CATALOG
NULL
CONSTRAINT_SCHEMA
CONSTRAINT_NAME
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
ORDINAL_POSITION
POSITION_IN_UNIQUE_CONSTRAINT
REFERENCED_TABLE_SCHEMA
REFERENCED_TABLE_NAME
REFERENCED_COLUMN_NAME
Notes:
• If the constraint is a foreign key, then this is the column of the foreign key, not the column that the
foreign key references.
• The value of
ORDINAL_POSITION
is the column's position within the constraint, not the column's
position within the table. Column positions are numbered beginning with 1.
• The value of
POSITION_IN_UNIQUE_CONSTRAINT
is
NULL
for unique and primary-key constraints.
For foreign-key constraints, it is the ordinal position in key of the table that is being referenced.
Suppose that there are two tables name
t1
and
t3
that have the following definitions:
CREATE TABLE t1
(
s1 INT,
s2 INT,
s3 INT,
PRIMARY KEY(s3)
) ENGINE=InnoDB;
CREATE TABLE t3
(
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...