[SQL] SQL command Error: "create table ... Like parentTable including defaults"

[Ying Lu]

Greetings,

I have a simple question about SQL command :
create table tableName1 LIKE parentTable   INCLUDING defaults ;


I was trying to create table "tableName1" with the same structure as 
"parentTable" without any data. I got a syntax error: 
'syntax error at or near "like" ... '

I guess there must be something wrong with my sql command, could 
somebody help?

Thanks a lot,
Emi

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match