You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Brandon Dohman <B-...@gotcg.net> on 2008/04/10 20:38:01 UTC

viewing table structure

In oracle you can do a describe statement on a table to view its structure.  Is it possible to do something similar with derby?

 

Thanks

B


No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.519 / Virus Database: 269.22.10/1367 - Release Date: 4/9/2008 7:10 AM

Re: viewing table structure

Posted by Rick Hillegas <Ri...@Sun.COM>.

Hi Brandon,

The Derby interactive sql tool, ij, supports a describe command, which 
you can use to display the structure of tables and views. You can find 
an explanation of this command in the "ij commands and errors reference" 
section of the Derby Tools and Utilities Guide: 
http://db.apache.org/derby/docs/10.3/tools/ Just look for the subsection 
titled "Describe command".

Hope this helps,
-Rick

Brandon Dohman wrote:
>
> In oracle you can do a describe statement on a table to view its 
> structure.  Is it possible to do something similar with derby?
>
>  
>
> Thanks
>
> B
>
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.519 / Virus Database: 269.22.10/1367 - Release Date: 
> 4/9/2008 7:10 AM
>