USER_IND_COLUMNS 这个表有什么作用?

[linlinbaobao]

额...如题..小问题.
请赐教 .

[秋雨飘落]

user_ind_columns 用户的索引对应的表列信息

[tangren]

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.

SQL> desc user_ind_columns;
Name            Type           Nullable Default Comments                                                        
--------------- -------------- -------- ------- --------------------------------------------------------------- 
INDEX_NAME      VARCHAR2(30)   Y                Index name                                                      
TABLE_NAME      VARCHAR2(30)   Y                Table or cluster name                                           
COLUMN_NAME     VARCHAR2(4000) Y                Column name or attribute of object column                       
COLUMN_POSITION NUMBER         Y                Position of column or attribute within index                    
COLUMN_LENGTH   NUMBER         Y                Maximum length of the column or attribute, in bytes             
CHAR_LENGTH     NUMBER         Y                Maximum length of the column or attribute, in characters        
DESCEND         VARCHAR2(4)    Y                DESC if this column is sorted descending on disk, otherwise ASC 

[dut703]

下一个联机文档，自己查下

[yejihui9527]

select * form user_ind_columns

[Rotel-刘志东]

用户对应索引的表的列。