Re: SQL question

In article <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?

You can't *direcly* delete a column from a table. But you can do the following to achieve the same effect:
1. CREATE TABLE <new_table> (... your new table structure ...) AS

    SELECT <.. the field you want to exist ..> FROM <old_table> 2. DROP TABLE <old_table>
2. RENAME <new_table> TO <old_table>

I have tried but this should work.

Hope this help.

Ken Received on Sun Oct 02 1994 - 14:36:10 CET