Re: Eliminate one column in select?

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Mon, 04 Oct 1999 17:10:23 GMT
Message-ID: <3c5K3.2361$S2.20764818@France.EU.net>

No , sorry !
But you can user views !

Regards

John F. Burrill <burrill_at_sourceworks.com> a écrit dans le message : 37F8B3AB.9970B681_at_sourceworks.com...
> *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 - 12:10:23 CDT