日期:2014-05-17  浏览次数:20966 次

USER_IND_COLUMNS 这个表有什么作用?
额...如题..小问题.
请赐教 .

------解决方案--------------------
user_ind_columns 用户的索引对应的表列信息 

------解决方案--------------------
SQL code
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

------解决方案--------------------
用户对应索引的表的列。