Re: Create table and index in one script

Yes, you can.
 
On Tue, May 30, 2017, at 21:08, Keith Squier wrote:
> Can I include functions, procedures, and triggers? Ultimately I would
> like to have a single script that creates the entire schema in one
> transaction.>  
> On Mon, Jan 16, 2017 at 5:02 AM, Fred Toussi
> <[email protected]> wrote:>> The statements are compiled before they are executed. The CREATE
>> INDEX statements is compiled before the table is created therefore
>> compilation fails due to the non-existent table.>>  
>> It is possible to create a whole schema in one transaction, including
>> all the constraints and indexes. See the Guide, Schemas and Database
>> Objects chapter. In the example below, note the lack of semicolon at
>> the end of inner statements and the single semicolon at the end:>>  
>>  CREATE SCHEMA ACCOUNTS AUTHORIZATION DBA   CREATE TABLE AB(A
>>  INTEGER)   CREATE TABLE CD(C CHAR(10))   CREATE INDEX IDX ON AB(A);>>  
>> Fred Toussi
>>  
>> On Thu, Jan 12, 2017, at 23:35, Keith Squier wrote:
>>> I am having difficulty creating tables and indexes all in one
>>> script. A simple example is below.>>>  
>>> CREATE TABLE A (
>>>    id UUID NOT NULL,
>>>    datetime TIMESTAMP NOT NULL,
>>>    PRIMARY KEY (id));
>>>  
>>> CREATE INDEX a_datetime_idx ON A (datetime);
>>>  
>>> When I run both statements in a single transaction, I get errors
>>> that the table is not found. If I run them in separate transactions,
>>> everything works. Is it not possible to create tables and their
>>> indexes all in one transaction?>>> --------------------------------------------------------------------
>>> ---------->>> Developer Access Program for Intel Xeon Phi Processors
>>> Access to Intel Xeon Phi processor-based developer platforms.
>>> With one year of Intel Parallel Studio XE.
>>> Training and support from Colfax.
>>> Order your platform today. http://sdm.link/xeonphi
>>> _________________________________________________
>>> Hsqldb-user mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>>
>>  --------------------------------------------------------------------
>>  ----------
>>  Developer Access Program for Intel Xeon Phi Processors Access to
>>  Intel Xeon Phi processor-based developer platforms. With one year of
>>  Intel Parallel Studio XE. Training and support from Colfax. Order
>>  your platform today. http://sdm.link/xeonphi
>>  _______________________________________________
>>  Hsqldb-user mailing list [email protected]
>>  https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>>> ----------------------------------------------------------------------
> --------> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _________________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user