How do I remove a comment from view?

Moderator: NorbertKrupa

Post Reply
User avatar
Jbaskin
Intermediate
Intermediate
Posts: 61
Joined: Sat Jan 28, 2012 1:21 pm

How do I remove a comment from view?

Post by Jbaskin » Thu Aug 29, 2013 4:35 pm

How can I delete a comment that was added to a view?

Code: Select all

dbadmin=> select comment from comments where object_name = 'store_location_dim';                   
                comment
----------------------------------------
 Location dimension for store locations
(1 row)
I tried this:

Code: Select all

dbadmin=> delete from comments where object_name = 'store_location_dim';
ERROR 2058:  DELETE from VIEW is not supported
But that didn't work...

User avatar
Julie
Master
Master
Posts: 221
Joined: Thu Apr 19, 2012 9:29 pm

Re: How do I remove a comment from view?

Post by Julie » Thu Aug 29, 2013 4:42 pm

I had the same question myself! I found out we just have to set the comment to NULL...

COMMENT ON VIEW <<object_type>> <<object_name>> IS NULL;

:D
Thanks,
Juliette

User avatar
Jbaskin
Intermediate
Intermediate
Posts: 61
Joined: Sat Jan 28, 2012 1:21 pm

Re: How do I remove a comment from view?

Post by Jbaskin » Thu Aug 29, 2013 9:38 pm

Dah! Thanks, Julie. I should of thought of that one.

Post Reply

Return to “New to Vertica”