select table_name,comments from user_tab_comments;
select table_name,column_name,comments from user_col_comments;
--导出表的注释
set heading off;
set echo off;
set feedback off;
set termout on;
spool C:\table_comment.sql;
SELECT 'comment on table ' || t.table_name || ' is ''' || t.comments ||''';' FROM user_tab_comments t;
spool off;
--导入表的注释
@ C:\table_comment.sql;
--导出表字段的注释
set heading off;
set echo off;
set feedback off;
set termout on;
spool C:\column_comment.sql;
SELECT 'comment on column ' || t.table_name || '.' || t.column_name || ' is ''' || t.comments ||''';' FROM user_col_comments t;
spool off;
--导入表字段的注释
@ C:\column_comment.sql;