Aqua Data Studio 15.0.0-dev-122
Database:Vertica 7.0
Build #: 36196
Built on: 2014-Feb-19 06:16:32 PM
Connect to Vertica Database.
Select Database option from server tree node,expand it,select public schema,
expand it,select table folder,right click on it and select option
create table.
Here it is observe that in create table UI side comment on table tab is missing.
When we execute the following query on query analyzer window we are able to add
the comment script to the table successfully.
COMMENT ON TABLE "test_comment" is 'TESTING COMMENT ON TABLE'
GO
Vertica does support adding comment to the following objects:
COMMENT ON COLUMN
COMMENT ON CONSTRAINT
COMMENT ON FUNCTION
COMMENT ON LIBRARY
COMMENT ON NODE
COMMENT ON PROJECTION
COMMENT ON SCHEMA
COMMENT ON SEQUENCE
COMMENT ON TABLE
COMMENT ON TRANSFORM FUNCTION
COMMENT ON VIEW
When we execute the following query on query analyzer window,it will display comment added to the table.
Select object_name,comment from V_CATALOG.COMMENTS
Moved to future and assigned to sachin to decide when we want to support comments on objects. Sachin, please discuss with me before deciding on schedule as vetica uses projections with tables just been a pointer to the projection.