视图中能添加类似表中Comments吗？

[anbeel]

能查询到视图中所有的字段名称,类型等。。。。但是怎样将字段的Comments添加到

user_col_comments视图中呢？

[anbeel]

谢谢两位！

[welyngj]

跟表一样：
COMMENT ON
{ TABLE [schema .] { table | view | materialized view }
| COLUMN [schema .] { table . | view . | materialized view . } column
| OPERATOR [schema .] operator
| INDEXTYPE [schema .] indextype
}
IS 'text';



To insert an explanatory remark on the job_id column of the employees table, you might issue the following statement:

COMMENT ON COLUMN employees.job_id
IS 'abbreviated job title';

[zlqs]

COMMENT ON COLUMN VIEW_NAME.COL_NAME IS 'COMMENT_VAL';