Search code examples
sqldatabasederby

how to describe and show table in DERBY DB?

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

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.