Re: [ProgSoc] Deleting Columns from Tables in SQL

[Simon Blainey <sblainey@nospam.socs.uts.edu.au>]

On Mon, 30 Mar 1998, Kevin Doohan wrote:

->Simple question?

don't think it's so simple...

->Does anyone know how I delete a column from an existing table (with data in it) using SQL?
->I am the owner of the table.

i think you might have to create a new table and copy the data across.
becuase as I remember it the delete SQL command deletes rows (as one would
expect!)



Regards,                                           sblainey@nospam.socs.uts.edu.au
Simon..                                          scatter@nospam.progsoc.uts.edu.au

http://www.progsoc.uts.edu.au/~scatter

 "Baldrick, believe me: eternity in the company of Beezlebub and all his
  hellish instruments of death will be a picnic compared to five minutes
  with me -- and this pencil -- if we can't replace this Dictionary."
  -- Edmund Blackadder III (Ink and Incapability)	

--
You are subscribed to the progsoc mailing list. To unsubscribe, send a
message containing "unsubscribe" to progsoc-request@nospam.progsoc.uts.edu.au.
If you are having trouble, ask owner-progsoc@nospam.progsoc.uts.edu.au for help.

This list is archived at <http://www.progsoc.uts.edu.au/lists/progsoc/>