·  SQL – Data Dictionary Views

 

- Info:

  - These are tables that contain specific informations about user and his objects.

 

- Examples:

  SELECT *                 -- TABLE_NAME, COMMENTS

  FROM   DICTIONARY        -- Lists tables which contain informations about user and his objects.

 

  SELECT *                 -- OBJECT_NAME, OBJECT_TYPE, CREATED, STATUS

  FROM   USER_OBJECTS      -- Lists tables owned by user.

 

  SELECT *                 -- VIEW_NAME, TEXT

  FROM   USER_VIEWS        -- Lists views owned by user.

 

  SELECT *                 -- SYNONYM_NAME, TABLE_OWNER, TABLE_NAME, DB_LINK

  FROM   USER_SYNONYMS     -- Lists synonyms owned by user.

 

  SELECT *                 -- SEQUENCE_NAME, MIN_VALUE. MAX_VALUE, INCREMENT_BY

  FROM   USER_SEQUENCES    -- Lists sequences owned by user.

 

  SELECT *                 -- OWNER, CONSTRAINT_NAME, TABLE_NAME

  FROM   USER_CONSTRAINTS  -- Lists constraints owned by user.

 

  SELECT *                 -- OWNER, CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAME

  FROM   USER_CONS_COLUMNS -- Lists on which table and column constraint applies.

 

  SELECT *                 -- TABLE_NAME, COLUMN_NAME, DATA_TYPE

  FROM   USER_TAB_COLUMNS  -- Lists table columns of tables owned by user.

 

  SELECT *                 -- TABLE_NAME, TABLE_TYPE, COMMENTS

  FROM   USER_TAB_COMMENTS -- Lists table comments of tables owned by user.

 

  SELECT *                 -- TABLE_NAME, COLUMN_NAME, COMMENTS

  FROM   USER_COL_COMMENTS -- Lists column comments of tables owned by user.