Chapter 3 DBMS Reference Guide

TableComment

Statement for adding a table comment. The table comment is a SQL statement which is not supported by all DBMS. If TableComment is empty, the Comment check box in the Tables and Views tab of the Database Generation box is grayed and unavailable.

Used in generation and reverse engineering.

Example

In Sybase SQL Anywhere 5.5:

TableComment = comment on table %OWNERPREFIX%%TABLE% is '%COMMENT%'

The %TABLE% variable is the name of the table defined in the List of Tables, or in the table property sheet. The %COMMENT% variable is the comment defined in the Comment textbox of the table property sheet.

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