var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Syntax for Create a new table from old table.
I need to create a new table from already existing table. I tried the following syntax, but it doesn't work.
create table new_table as select * from old_table;
create table new_table like old_table;
Informix do not have this syntax...
you must execute a dbschema -d <database> -t <table> <-ss>
and alter the table name...
I am not a regular Informix user, but I think the following should work:
Originally Posted by sarwan
select * from old_table into new_table;
the correct syntax is :
select * from old_table into TEMP new_table
and this way you will create just a temporary table...
unfortunately must use the dbschema to do this job...
Originally Posted by ceinma
Now it does! As of Informix version 12.10 we support this syntax for permanent tables:
create table tab2 as select * from tab1;