Chapter 3 DBMS Reference Guide


ViewComment

Statement for adding a view comment. The view comment is a SQL statement. It is not supported by all DBMS. If this parameter is empty, the Comment check box in the Views groupbox in the Tables & Views tab of the Generate Database box is grayed and unavailable.

Example

In Oracle 8:

comment on table [%QUALIFIER%.]%VIEW% is '%COMMENT%'

The %VIEW% variable is the name of the view defined in the List of Views, or in the view property sheet. The %COMMENT% variable is the comment defined in the Comment textbox in the View property sheet.

 


Copyright (C) 2005. Sybase Inc. All rights reserved.