[MonetDB-users] create table like

3 Jan 2010

      Martin,

Thank you for the quick reply.

Martin Kersten wrote:
...
...
create table t2 as (select * from t1 limit 1) with data;
This is improper SQL syntax.
Limit can only be placed on the result set.
Okey. Here is another issue.

create table t1 (f1 int);
create table t2 like t1;

syntax error, unexpected LIKE, expecting AS in: "create table t2 like"

Is "create table like" statement as in the document supported in the 
current release?
http://monetdb.cwi.nl/SQL/Documentation/Table-Management.html

Thanks,
Makoto

[MonetDB-users] create table like

Makoto YUI