RE: How to create a table from an existing table?

select col1, col3 into table2 from table1 :) Haiyun -----Original Message----- From: Mahmoud Kamoun [mailto:kamounm@usgs.gov] Sent: Thursday, April 06, 2000 10:16 AM To: informix-list@iiug.org Subject: How to create a table from an existing table? I want to create a table from an other table containing data but only few columns will be selected. e.g table table1 has col1, col2, col3, col4 col5 I want to create a table table2 with data from table1.col1 table1.col3 only. a command like "create table2 as select col1, col3 from table1" Thanks