how to describe and show table in DERBY DB?

database, derby, sql

Solution

Strictly speaking, this isn't SQL. Rather, these are IJ commands, and must be processed by the IJ tool.

Here's the documentation for "describe": http://db.apache.org/derby/docs/10.10/tools/rtoolsijcomrefdescribe.html

And here's the documentation for "show tables": http://db.apache.org/derby/docs/10.10/tools/rtoolsijcomrefshow.html

You don't run these commands in Websphere, you run them in IJ.

Problem

I have this SQL query ``` 1 : show tables 2 : desc tablename ``` But this doesn't seem to be the syntax in the derby. How to write these queries in derby ?? I want to check the schema of a table whether its primary key or not. How to check that in websphere

Original source