数据字典

--约束

SQL> desc user_ind_columns

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 INDEX_NAME                                         VARCHAR2(30)
 TABLE_NAME                                         VARCHAR2(30)
 COLUMN_NAME                                        VARCHAR2(4000)
 COLUMN_POSITION                                    NUMBER
 COLUMN_LENGTH                                      NUMBER
 CHAR_LENGTH                                        NUMBER
 DESCEND                                            VARCHAR2(4)

SQL> Select CONSTRAINT_NAME,TABLE_NAME,R_OWNER,R_CONSTRAINT_NAME
FROM All_Constraints 
WHERE Owner = 'SCOTT' And Table_Name='EMP';

--序列

SQL> desc user_objects                            
 Name                    Null?    Type            
 ----------------------- -------- ----------------
 OBJECT_NAME                      VARCHAR2(128)   
 SUBOBJECT_NAME                   VARCHAR2(30)    
 OBJECT_ID                        NUMBER          
 DATA_OBJECT_ID                   NUMBER          
 OBJECT_TYPE                      VARCHAR2(18)    
 CREATED                          DATE            
 LAST_DDL_TIME                    DATE            
 TIMESTAMP                        VARCHAR2(19)    
 STATUS                           VARCHAR2(7)     
 TEMPORARY                        VARCHAR2(1)     
 GENERATED                        VARCHAR2(1)     
 SECONDARY                        VARCHAR2(1)     
 

SQL> select object_name from user_objects where  object_type='SEQUENCE';