Sybase SQL Anywhere - COMMENT ON COLUMN - Add Comment for Column

COMMENT ON COLUMN statement adds a comment for a column in the table.

Quick Example:

   -- Define a table
   CREATE TABLE location (city VARCHAR(90));
 
   -- Add a comment for city column
   COMMENT ON COLUMN location.city IS 'This is the city name';

COMMENT ON COLUMN Overview

Summary information:

Syntax (full...) COMMENT ON COLUMN [owner.]table_name.column_name IS 'Comment string'
How to Remove Comment COMMENT ON COLUMN table.column IS NULL
Transactions Automatic COMMIT is performed after COMMENT ON COLUMN statement

Last Update: Sybase SQL Anywhere 12.0

Sybase SQL Anywhere COMMENT ON COLUMN Conversion to Other Databases

Sybase SQL Anywhere COMMENT ON COLUMN statement in other databases.

Oracle:

COMMENT ON COLUMN The same syntax, no conversion required Changes in identifiers may be required

Sybase SQL Anywhere Resources