Re: How to delete a column?

In article <48ajh0$cp4_at_news.internetmci.com>, anthony_ly_at_mcimail.com (Anthony Ly) writes:
|> Here is the procedure to delete a column:
 

|> 2. Create a new copy of the table (not including the columns you
|> wanna drop)
|> 3. Use an insert statement to migrate data over:
|> i.e. INSERT INTO newtable SELECT col1,col2,.... FROM oldtable
These two steps can be done in one SQL statement:

        CREATE TABLE newtable AS SELECT col1,col2,... FROM oldtable;

---
Alexander Lukyanov
lav_at_video.yars.free.net