1 SELECT tabCols.COLUMN_NAME AS "Field",
2 tabCols.DATA_TYPE || '(' || tabCols.DATA_LENGTH || ')' AS "Type",
3 cons.constraint_type as "Key",
4 tabCols.NULLABLE AS "Null",
5 colcomments.comments AS "Comment"
6 FROM USER_TAB_COLS tabCols
7 inner JOIN user_col_comments colcomments
8 ON colcomments.TABLE_NAME = tabCols.TABLE_NAME
9 AND colcomments.COLUMN_NAME = tabCols.COLUMN_NAME
10 left JOIN user_cons_columns conscols
11 on conscols.TABLE_NAME = tabCols.TABLE_NAME
12 AND conscols.COLUMN_NAME = tabCols.COLUMN_NAME
13 left join user_constraints cons
14 ON cons.constraint_name = conscols.constraint_name
15 where tabCols.TABLE_NAME = 'TBTEST'
