SQL读取视图及描述【ORACLE】

147 阅读1分钟

/获取表字段及描述/

select * from user_col_comments ucc where ucc.TABLE_NAME = 'VM_SPC_COUNTING_RTA_TEST'

/获取表名及描述/

select TABLE_NAME AS Name,COMMENTS AS Note from user_tab_comments where TABLE_NAME like 'VM_SPC_%' order by TABLE_NAME

/创建表的描述/

COMMENT ON TABLE DEV_831.VM_SPC_COUNTING_RTA_TEST IS '视图_计数数据集'