Re: newbie question: how to delete a column from a table definition

jk <john_at_demon.co.uk> wrote in article
<892506212.28385.0.nnrp-04.c2de082b_at_news.demon.co.uk>...
> No you don't have to do all that
> just use
>
> create table mynewtable as select .... from myoldtable
>
> ie after the select just choose the columns you want.
>
> ps if you dont want the data in your old table just put an impossible
condition
> in the where clause.

That will get only the data over, but the indexes (if any) on myoldtable won't come over. You still have to create those on mynewtable.

--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com Received on Tue Apr 14 1998 - 17:00:18 CDT