Ray,
Go to Tools>Rlationships, you will see your your relationships there.
Go to any table and open the table desinger. Select Tools>Index Design.
You will see the indexes that where created.
Finally, you can go back to the SQL dialog and issue a SCRIPT <file
name> name command. Opening the file that is created will show you
everythig that the engine created from your DDL commands.
HTH
Andrew Jensen
Ray Jahn wrote:
OO: 1.9.130
OS: MS Windows XP
I am not sure whether this is a question for OpenOffice Base or
HSQLDB. How could I make the SQL statement "Show Tables;" work in
OpenOffice?
-- test steps
Start OpenOffice Base 1.9.130
startup options
create a new database
do not register database
open database for editing
file name - your choice
Select the Tables icon in the left Database pane.
Tools - SQL - enter the following SQL code
press Execute button in SQL dialog
Command successfully executed - in status field, OK
close the SQL dialog
The newly created tables are not displayed yet in the main window.
menu command: View - Refresh tables
Should see the newly created tables - OK.
Right click the table "t junk".
Select option Edit.
*** ***
I could not find a way to verify the the complete referential
constraint, especially the "On Delete" and "On Update" portions.
(Also tried the SQL dialog in 1.9.130.)
Thanks for advice.
R. Jahn
-- OpenOffice 1.9.130 HSQLDB
Create Table "tt entity"
(
"ID numeric" Integer,
"ID symbolic" VarChar( 50 ) Not Null,
Constraint pk_tt_entity Primary Key ( "ID numeric" ),
Constraint uq_tt_entity Unique ( "ID symbolic" )
);
Create Table "tt event type"
(
"ID numeric" Integer,
"ID symbolic" VarChar( 50 ) Not Null,
Constraint pk_tt_evt_type Primary Key ( "ID numeric" ),
Constraint uq_tt_evt_type Unique ( "ID symbolic" )
);
Create Table "tt event data"
(
"event entity" Integer Not Null,
"event type" Integer Not Null,
"event date" Date Not Null,
"event note" VarChar( 50 ),
-- dummy, 1.9.130 requires unique index to permit table entry
"event ID" BigInt Identity,
Constraint fk_event_entity
Foreign Key ( "event entity" )
References "tt entity" ( "ID numeric" )
On Update Cascade
On Delete Restrict,
Constraint fk_event_type
Foreign Key ( "event type" )
References "tt event type" ( "ID numeric" )
On Update Cascade
On Delete Restrict
-- Constraint uq_evt_dummy Unique ( "event ID" )
);
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
