Comments to Describe Tables and Views
When working with tables and views in applications, it is helpful to include commentary about the structure and uses of tables and views.
Tables and views can be commented with:
• Comment lines in SQL or a host language, for example, “/*comment*/” or “--comment”
• Comments specified with the COMMENT ON statement
• Comments in embedded SQL (ESQL) programs specified with the DECLARE TABLE statement
When using Director or VDBA, tables and views are self-documenting. For example, you can see the definition of a view at a glance, as well as its rows and the grants that have been defined. For a table, you can view its rows and columns, as well as properties, statistics, and other pertinent information.