How to check the underlying SQL in Base
I'm using Libre Office 220.127.116.11 Base with the inbuilt HSQL. (on Windows XP)
I am setting up a database, creating the tables in design view. But some of the commands need to be input via Tools/SQL e.g. adding table constraints such as UNIQUE or CHECK. I am naming my constraints and keeping a list of them. But what I can't see how to do is to look at the underlying SQL so that I can check up on previously entered constraints. Is there a way of doing this?
many thanks Ruth