Re: SQL question

From: Richard Armstrong <rarmstro_at_ix.netcom.com>
Date: 4 Oct 1994 04:07:26 GMT
Message-ID: <36qkdu$ips_at_ixnews1.ix.netcom.com>


In <36e7s6$n0f_at_nuscc.nus.sg> fbap3120_at_leonis.nus.sg (Virinchipuram J. A.) writes:

>
>
>Hi Gurus!
>
>One "easy" question, how do I delete a column name from a created table?
>
>Thanks for the effort
>
>-anand
>
>--
>Anand. V. J Internet:fbap3120_at_leonis.nus.sg
>Dept Of Decision Sciences
>National University Of Singapore
>
>

Copy the table (selecting only those columns you want) into a temporary table using the create table command. Then drop the original table, and copy it back from the temp table.

-Richard Received on Tue Oct 04 1994 - 05:07:26 CET

Original text of this message