Eliminate one column in select?

*Please respond to burrill_at_sourceworks.com

I have several tables with an assortment of columns. Each table has one column in common "my_column".

What I want to do is create copies of those tables without the "my_column" column. So in theory:

create table new_Table1
as select (* - my_column)

    from Table1;

Is there a way to do this without specifying the other columns?

Kindest regards,
John.

*Please respond to burrill_at_sourceworks.com
Received on Mon Oct 04 1999 - 09:03:24 CDT