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';
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 statement in other databases.
Oracle:
COMMENT ON COLUMN | The same syntax, no conversion required | Changes in identifiers may be required |