如何在DERBY DB中描述和显示表？ [英] how to describe and show table in DERBY DB?

问题描述

我有这个SQL查询

1 : show tables
2 : desc tablename

但这似乎不是德比语法。

But this doesn't seem to be the syntax in the derby.

如何在derby中编写这些查询？

How to write these queries in derby ??

我想检查表的模式是否为主键。

I want to check the schema of a table whether its primary key or not.

如何在Websphere中检查

How to check that in websphere

推荐答案

严格来说，这不是SQL。而是这些是IJ命令，并且必须由IJ工具处理。

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

以下是描述的文档： http://db.apache.org/derby/docs/10.10/tools/rtoolsijcomrefdescribe.html

这是显示表的文档： http://db.apache.org/derby/docs/10.10/tools/rtoolsijcomrefshow.html

您不运行这些命令在Websphere中运行，您可以在IJ中运行它们。

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

这篇关于如何在DERBY DB中描述和显示表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！