Oracle 5.0, Справочное руководство

Страница: 1739 / 3232

The
INFORMATION_SCHEMA COLUMN_PRIVILEGES
Table
1719
INFORMATION_SCHEMA
Name
SHOW
Name Remarks
NUMERIC_PRECISION Type
NUMERIC_SCALE Type
CHARACTER_SET_NAME
COLLATION_NAME Collation
COLUMN_TYPE Type
MySQL extension
COLUMN_KEY Key
MySQL extension
EXTRA Extra
MySQL extension
PRIVILEGES Privileges
MySQL extension
COLUMN_COMMENT Comment
MySQL extension
Notes:
• In
SHOW
, the
Type
display includes values from several different
COLUMNS
columns.
•
ORDINAL_POSITION
is necessary because you might want to say
ORDER BY
ORDINAL_POSITION
. Unlike
SHOW
,
SELECT
does not have automatic ordering.
•
CHARACTER_OCTET_LENGTH
should be the same as
CHARACTER_MAXIMUM_LENGTH
, except for
multi-byte character sets.
•
CHARACTER_SET_NAME
can be derived from
Collation
. For example, if you say
SHOW FULL
COLUMNS FROM t
, and you see in the
Collation
column a value of
latin1_swedish_ci
, the
character set is what is before the first underscore:
latin1
.
The following statements are nearly equivalent:
SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = ' tbl_name '
[AND table_schema = ' db_name ']
[AND column_name LIKE ' wild ']
SHOW COLUMNS
FROM tbl_name
[FROM db_name ]
[LIKE ' wild ']
19.5. The
INFORMATION_SCHEMA COLUMN_PRIVILEGES
Table
The
COLUMN_PRIVILEGES
table provides information about column privileges. This information comes
from the
mysql.columns_priv
grant table.
INFORMATION_SCHEMA
Name
SHOW
Name Remarks
GRANTEE 'user_name'@'host_name'
value
TABLE_CATALOG NULL
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
PRIVILEGE_TYPE
IS_GRANTABLE
Notes: