#11 HSQLDB: CREATE CACHED TABLE

[Thomas Mueller]

There needs to be a way to specify vendor specific
options for create table (maybe for other statements as
well). If the option is not available for a selected
database, it is ignored.

[Thomas Mueller]

Logged In: YES
user_id=15973

I suggest the following syntax for statement options:

CREATE TABLE TEST OPTION('CACHED')
(ID INT PRIMARY KEY, NAME VARCHAR(255))

Like this, it is possible to add optional attributes (for
example, some of the various options of Oracle). And there
is no need to add additional keywords (OPTION is already a
keyword). What do you think?

Thanks,
Thomas

[Thomas Mueller]

Logged In: YES
user_id=15973

If you have anonymous CVS access you can try the feature out
- it is already implemented.

CREATE TABLE A OPTION('CACHED') (ID INT,VALUE VARCHAR(255))

[Vladimirov Sergey]

Logged In: YES
user_id=854317

I think more correct to use one of SQL dialect, like Oracle,
HSQLDB or MySQL for adding keywords.

I don't think, that create new dialect of SQL is good idea.