Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 26 May 2011 @ 19:49:58 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Clearing a Comment from an object
From:   DWellman

Hi folks,

A question from a class today and no, it's not overly important but I'd be interested in the answer.

When you create an object the 'Comment value' for that object is NULL.

You can change the comment by issuing: COMMENT ON TABLE t1 AS 'this is a comment';

How do you change the comment back to a NULL ?

If you use " COMMENT ON TABLE t1 AS ''; " then you correctly get the commentstring set to a zero-length string (which is not the same as NULL).

I tried COMMENT ON TABLE t1 AS NULL; but that failed with a 3706 syntax error (TD 13.0).

So, apart from running an UPDATE statement directly against the underlying DBC table, can you change the comment for an object back to NULL?



Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023