Can you do the columns too while you're at it? Being able to embed documentation is already a good thing. For example, we could document the repository this way.
Also, do you plan to extend showddl to show the comments? Or, some other means? Thanks, Gunnar On Fri, Apr 1, 2016 at 7:02 AM, Liu, Ming (Ming) <[email protected]> wrote: > Very good plan QiFan. > > Allow me file a JIRA then. > > > > Compatibility will be important. > > > > Thanks, > > Ming > > > > *发件人:* Qifan Chen [mailto:[email protected]] > *发送时间:* 2016年4月1日 18:31 > *收件人:* [email protected] > *主题:* Re: 答复: add a comment to a table > > > > The implementation probably will be involving the following: > > 1. add a new type for column TEXT_TYPE in meta-table > TRAFODION."_MD_".TEXT, say COMMENT_TYPE; > 2. allow COMMENT ON syntax in the parser; > 3. convert the content of COMMENT ON stmt into insertion/update of a > row(s) in the TEXT meta-data table for the SQL object in question; > 4. write a UDF to show the comment easily for a SQL object, by hiding > the join of the meta-data TEXT and OBJECTS table. > > The task may be a little bit involving :-). > > > > Thanks --Qifan > > > > On Fri, Apr 1, 2016 at 1:30 AM, Liu, Ming (Ming) <[email protected]> > wrote: > > Shall we file a JIRA to track this requirement? > > > > Thanks, > > Ming > > > > *发件人**:* Suresh Subbiah [mailto:[email protected]] > *发送时间**:* 2016年4月1日 11:54 > *收件人**:* [email protected] > *主题**:* Re: add a comment to a table > > > > Hi, > > > > I do not think Trafodion currently supports Oracle's COMMENT ON syntax > > *https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4009.htm > <https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4009.htm>* > > > > *It will be a relatively simple feature to add but we do not have it today > as far as I know.* > > > > *Thank you* > > *Suresh* > > > > > > On Thu, Mar 31, 2016 at 9:56 PM, [email protected] < > [email protected]> wrote: > > Hi , all, > > > > > > I want to add a comment to a table,like the use of oracle" > comment on table tablename > is annotate", How to use jdbc way to implement it? > > > > > > > > > ------------------------------ > > [email protected] > > > > > > > > -- > > Regards, --Qifan > > > -- Thanks, Gunnar *If you think you can you can, if you think you can't you're right.*
