[ http://issues.apache.org/jira/browse/DERBY-1659?page=comments#action_12434702 ] Andreas Korneliussen commented on DERBY-1659: ---------------------------------------------
I have just a minor comment on the doc: I have been testing this feature, and found that descrbie also can be used for describing views. ij> show views; TABLE_SCHEM |TABLE_NAME |REMARKS ------------------------------------------------------------------------ MYPP |V1 | 1 row selected ij> describe mypp.v1; COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& ------------------------------------------------------------------------------ C |INTEGER |0 |10 |10 |NULL |NULL |NO 1 row selected Therefore, I propose that the doc is modified to say that it can describe views, and the syntax of the describe command could i.e be: describe <view_name>|<table_name> > Document describe and show tables functionality > ----------------------------------------------- > > Key: DERBY-1659 > URL: http://issues.apache.org/jira/browse/DERBY-1659 > Project: Derby > Issue Type: Sub-task > Components: Documentation > Reporter: David Van Couvering > Assigned To: Andrew McIntyre > Fix For: 10.3.0.0 > > Attachments: derby-1659-andrew-1-html.zip, derby-1659-andrew-1.diff, > Describe.html, ShowProcedures.html, ShowSchemas.html, ShowSynonyms.html, > ShowTable.html, ShowViews.html > > > Need to add documentation for this new feature -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira