Ask Your Question

Database design, table design-view, constraints etc, SQL [closed]

asked 2017-04-05 15:21:11 +0100

Clockman gravatar image

updated 2020-09-29 12:57:06 +0100

Alex Kemp gravatar image

I've done a lot of database design but always with the advantage of using a data-dictionary system to generate the SQL to create the elements of the database, so I wanr to check that I am going down the right route. I am using WIndows 10 (64bit) and a local database.

  1. Table design. Can I create 'contraints' in the graphical table-design view? I have been adding them by entering SQL.

  2. Database structure SQL. I found the command "script , 'filename';" to extract details of everything in a database, including the data. Is there a version of this command to extract just the definitions of particular tables?

  3. Once I have a file of SQL commands to be run against the database, how do I accomplish this?

  4. How can I ensure that column descriptions (eg 'Customer Number') remain the same wherever they are used?

  5. Has anyone created a data-dictionary system?

That's definitely enough for now!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-29 12:57:20.010620

1 Answer

Sort by » oldest newest most voted

answered 2017-04-05 16:32:47 +0100

Ratslinger gravatar image

Your questions are oriented toward databases. Base is not a database but just a front end to databases. Base does come with "embedded" HSQL v1.8 but most are advised not to stick with that and to at least migrate to a split version (data external to .odb) with an upgraded HSQL. Many also use external DB's such as PostgreSQL, MySQL, MariaDB etc.

The only SQL which can be stored are queries. Other than queries (which include Meta data retrieval) SQL needs to be run through the main startup screen from the menu Tools->SQL and provides no storage for these statements. For storage of this type and much of your question, migrate away from the "embedded" HSQL and use an external tool such as SQL Workbench/J or MySQL Workbench or similar.

Also refer to the documentation of the specific database you are using. Here is the link for the included HSQL v1.8 - click here.

edit flag offensive delete link more


Thanks for that. I was thinking that LibreOffice Base was more like Microsoft Access than it actually is, and that was in about 2002. I have set up MySQL Workbench (Community version) which turns out to be what I required. Thanks again, Chris

Clockman gravatar imageClockman ( 2017-04-10 14:05:09 +0100 )edit

If this answers your question please click on the ✔ (upper left area of answer).

Ratslinger gravatar imageRatslinger ( 2017-04-10 14:55:06 +0100 )edit

Question Tools

1 follower


Asked: 2017-04-05 15:21:11 +0100

Seen: 559 times

Last updated: Apr 05 '17