how to describe and show table in DERBY DB?

Question

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

Answer 1

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.