• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1185
  • Last Modified:

IBM solidDB -- dump of table schema

  How do I get a dump of all the table  from a solidDB database?

The document say that you could use the describe command but I get an error


ADMIN COMMMAND 'describe dept';

SOLID SQL Error 1: syntax error (line 1 near 'DESCRIBE')
1 Solution
Tomas Helgi JohannssonCommented:

If you mean by dump to take a backup of all the database then you should issue the command
ADMIN COMMAND 'backup'  (see the following manual :)


However if you issue the
ADMIN COMMAND 'describe param'
command then it will return a description of all parameters or a parameter specified with param.

In your case you have written COMMMAND but it should be COMMAND. :)

     Tomas Helgi

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now