在我们接触一个新的系统时,往往要接触系统的数据库,要了解系统表,最好可以全局的浏览整个系统
select t.TABLE_NAME as 表名, a.comments as 表注释, t.COLUMN_NAME as 列名, s.DATA_TYPE || '(' || s.DATA_LENGTH || ')' as 列类型, t.COMMENTS as 列注释 from user_col_comments t, user_tab_comments a, user_tab_columns s where t.comments is not null and t.TABLE_NAME = a.TABLE_NAME and t.COLUMN_NAME = s.COLUMN_NAME and s.table_name = a.TABLE_NAME order by t.TABLE_NAME, t.COLUMN_NAME;
只查看表注释
select s.TABLE_NAME as 表名, s.comments as 表注释 from user_tab_comments s where s.comments is not null and s.table_type = 'TABLE' order by s.TABLE_NAME