Dear All,
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 ?

Thanks.

Rajac.

Hi,
try 'dbschema -d <database> -t <table>'(command line unix). This shows the create statement without storage option.
regards,
Chris