SQL 查看表字段及说明

select A.comments,A.column_name,B.DATA_TYPE||'('||B.DATA_LENGTH||')' from user_col_comments A inner join USER_TAB_COLS
B on A.table_name=B.TABLE_NAME
and A.column_name=B.COLUMN_NAME
and A.TABLE_NAME='BASE_DRUGINFO'
order by B.COLUMN_ID;