Re: [Hsqldb-user] Create Table

[fredt <fr...@us...>]

Up-to-date information on table types is on our website and there's no need
to repeat it.

Your list is more or less correct. Please note that Memory tables are
persistent and can be considered as normal database tables, although all the
data is held in memory while the database is in use.

Fred

---------------------

Thomas Tryde wrote:

What is the difference?
Memory
Cached
Temp
Text


Is this correct?
Memory: - Everything is stored in memory only?
Cached: - A normal database table, data is stored to disk but cached in
memory until the db is saved?
Temp: - A temporary table that is automatically destroyed when a
connection/session is disconnected.
Text: ?