oracle查询表的信息、列注释信息

/*查询表的列信息

all_tab_columns用户可访问的表列

dba_tab_columns所有表列

user_tab_columns当前用户所拥有的表列

*/

select * 
from all_tab_columns/dba_tab_columns/user_tab_columns
where TABLE_NAME=upper('table_duzhaozhao')

/*查询表的信息*/

select * 
from user_tables/all_tables

/*查询表的列注释信息*/

select * 
from all_col_comments/user_col_comments
where TABLE_NAME=upper('table_duzhaozhao')

/*给表的列添加注释信息*/

comment on column upsrdp.table_duzhaozhao.cust_actnum is '大规模' 
comment on column upsrdp.table_duzhaozhao.acct_nam is '大33模'

2022-1-22