Michael
Yes, you can use the column definition construct CREATE TABLE <tablename> ( LIKE <tablename> , <column def> )
for example: create table tmp( i int); create table t2( like tmp); create table t3 (like tmp, d int);
regards, Martin
On 5/25/11 9:46 AM, Stefan Manegold wrote:
Michael,
in user space, MonetDB/SQL completely follows the SQL standard, i.e., the conceptual data model are n-ary (multi-column) relational tables, just as with any other RDBMS. Physically, MonetDB "automatically" (and hence always) stores relational tables column-wise. That why it is also refered to as column-store. MonetDB does not come with any option to physically store relational tables row-wise.
Stefan
On Wed, May 25, 2011 at 09:33:17AM +0200, Michael K wrote:
Hi,
is there a "CREATE COLUMN TABLE xyz" like statement in MonetDB or will every "CREATE TABLE" create a column table? Can I create "normal" row store tables in MonetDB at all? I have read http://monetdb.cwi.nl/SQL/Documentation/Table-Definition.htmlbut did not found the information I was looking for.
Kind regards. michael
vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users