Selecting all columns except one column from a table
508434Aug 17 2006 — edited Aug 17 2006Hi,
I have a table with 453 columns. I am using a select statement to insert the values into another table. But in insert statement I don't want all columns like....
insert into table2 as Select * from table1;
Instead of this I only want 452 columns. Is there any simple way without mentioning all 452 columns explicitly to do this. I don't want to use any intermediate tables or views for this.
Thanks
Poulose