Oracle教程 2023-02-23

Oracle 视图 ALL_IND_COLUMNS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图ALL_IND_COLUMNS查询它所拥有的所有索引列的信息。该视图包含索引表、索引类型、列序号以及列名称。用户可以使用该视图来列举表中的所有索引、检查索引列信息(列名、索引类型等)。

使用方式：
SELECT index_name, table_name, column_name, column_position
FROM all_ind_columns
WHERE table_name=’指定的表名’
ORDER BY index_name;

官方英文解释

ALL_IND_COLUMNS describes the columns of indexes on all tables accessible to the current user.

Related Views

DBA_IND_COLUMNS describes the columns of indexes on all tables in the database.
USER_IND_COLUMNS describes the columns of indexes owned by the current user and columns of indexes on tables owned by the current user. This view does not display the INDEX_OWNER or TABLE_OWNER columns.

Note:

For join indexes, the TABLE_NAME and TABLE_OWNER columns in this view may not match the TABLE_NAME and TABLE_OWNER columns you find in the *_INDEXES (and other similar) data dictionary views.

Column	Datatype	NULL	Description
`INDEX_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the index
`INDEX_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the index
`TABLE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the table or cluster
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the table or cluster
`COLUMN_NAME`	`VARCHAR2(4000)`		Column name or attribute of the object type column Note: If you create an index on a user-defined `REF` column, the system creates the index on the attributes that make up the `REF` column. Therefore, the column names displayed in this view are the attribute names, with the `REF` column name as a prefix, in the following form: "REF_name"."attribute"
`COLUMN_POSITION`	`NUMBER`	`NOT NULL`	Position of the column or attribute within the index
`COLUMN_LENGTH`	`NUMBER`	`NOT NULL`	Indexed length of the column
`CHAR_LENGTH`	`NUMBER`		Maximum codepoint length of the column
`DESCEND`	`VARCHAR2(4)`		Indicates whether the column is sorted in descending order (`DESC`) or ascending order (`ASC`)
`COLLATED_COLUMN_ID`	`NUMBER`		Internal sequence number of the column for which this column provides linguistic ordering

本站中文解释

官方英文解释

相关推荐