Sybase SQL Anywhere - COMMENT ON TABLE - Add Comment for Table

COMMENT ON TABLE statement adds a comment for a table.

Quick Example:

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

COMMENT ON TABLE Overview

Summary information:

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

Last Update: Sybase SQL Anywhere 12.0

Sybase SQL Anywhere COMMENT ON TABLE Conversion to Other Databases

Sybase SQL Anywhere COMMENT ON TABLE statement in other databases.

Oracle:

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

Sybase SQL Anywhere Resources