Roman
Roman

Reputation: 66226

What is the most easy way to get ddl sql-script from HSQLDB?

In other words, how to export sql-script for building database and putting data into it from HSQLDB?

Upvotes: 1

Views: 1309

Answers (2)

Aleksandr Kravets
Aleksandr Kravets

Reputation: 5967

You can use Eclipse's Data Source Explorer. You can generate DDL for whole base or specify certain table. See picture
Data Source Explorer Generate DDL

I bet other IDE's also have similar feature.

Upvotes: 0

fredt
fredt

Reputation: 24382

Use

SCRIPT 'yourFilePathAndName'

It will save the database SQL script, including data, to the file you specify.

Upvotes: 1

Related Questions