Create table

Hi,

I have a table called tab1 with the following filelds: fld1, fld2 and fld3 and I want to create another table tab2 from tab1, with an additional field fld0 added at the beginning, i.e. fld0, fld1, fld2 and fld3, how can I do that?

Can I use syntax such as create table tabl2 ... as select ... from tabl1?

Yam. Received on Mon Dec 04 2006 - 09:08:14 CST