Oracle 注释
--给表加注释COMMENT?ON?TABLE?TABLENAME?IS?'用户表'?;--查看表的COMMENTSELECT?*?FROM?USER_TAB_COMMENTS?WHERE?TABLE_NAME=?'TABLENAME';--给字段加注释COMMENT?ON?COLUMN?TABLENAME.COLNAME?IS?'OOXX'?;--查看字段的COMMENTSELECT?*?FROM?USER_COL_COMMENTS?WHERE?TABLE_NAME=?'TABLENAME';--查看字段的详细信息SELECT??? T.TABLE_NAME 表名,??? T.COLUMN_NAME 字段名,??? T.DATA_TYPE 数据类型,??? T.DATA_LENGTH 长度,??? T.DATA_PRECISION 整数位,??? T.DATA_SCALE 小数位,??? T.NULLABLE 允许空值,??? T.DATA_DEFAULT 缺省值,??? C.COMMENTS 备注FROM?USER_TAB_COLUMNS T,USER_COL_COMMENTS CWHERE?T.TABLE_NAME = C.TABLE_NAMEAND?T.TABLE_NAME =?'TABLENAME'?;
