Unanswered: Create a new table based on existing table
I would like to create a new tabe based on an already existing table in informix 9.4 database. I don't want to have the records in the new table from the source table. I tried with the query
"Create table A as select * from B" and it ends up with Syntax error.
Could anyone please help me out in the correct sysntax for the above query ?