Oracle:
查询表基本信息:
select
utc.column_name,utc.data_type,ucc.comments,utc.data_length,utc.data_precision, utc.data_Scale,utc.nullable,utc.data_default
from
user_tab_columns utc,user_col_comments ucc
where
utc.table_name = ucc.table_name and utc.column_name = ucc.column_name and utc.table_name = 'xxx'
order by column_id