首页 > 数据库 > Oracle > note of Beginning Oracle SQL-Oracle Data Dictionary Views

note of Beginning Oracle SQL-Oracle Data Dictionary Views

Oracle 作者:nathanzhn 时间:2014-09-23 15:27:27 0 删除 编辑
Table 3-5. Some Useful Oracle Data Dictionary Views
View Description                                     
DICTIONARY Description of the data dictionary itself       
DICT_COLUMNS Data dictionary column descriptions             
ALL_USERS Information about all database users            
ALL_INDEXES All indexes                                     
ALL_SEQUENCES All sequences                                   
ALL_OBJECTS All objects                                     
ALL_SYNONYMS All synonyms                                    
ALL_TABLES All tables                                      
ALL_VIEWS All views                                       
USER_INDEXES Indexes                                         
USER_SEQUENCES Sequences                                       
USER_OBJECTS Objects                                         
USER_SYNONYMS Synonyms                                        
USER_TABLES Tables                                          
USER_TAB_COLUMNS Columns                                         
USER_VIEWS Views                                           
USER_RECYCLEBIN  Dropped objects                                 
CAT Synonym for USER_CATALOG                        
COLS Synonym for USER_TAB_COLUMNS                    
DICT Synonym for DICTIONARY                          
DUAL Dummy table, with one row and one column        
IND Synonym for USER_INDEXES                        
OBJ Synonym for USER_OBJECTS                        
SYN Synonym for USER_SYNONYMS                       
TABS Synonym for USER_TABLES                         

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录


  • 博文量
  • 访问量