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