List:General Discussion« Previous MessageNext Message »
From:Rolf Hopkins Date:February 19 2001 12:56am
Subject:Re: DROP COLUMN
View as plain text  
What are you using? MySQL or Microsoft SQL?  If it's Microsoft SQL, you have
come to the wrong place otherwise try using MyODBC instead.

Why do you have to store information in a temporary column?  Do you want to
keep the data in the column?

----- Original Message -----
From: "Wernher Korff" <wernher@stripped>
To: <mysql@stripped>
Sent: Friday, February 16, 2001 17:47
Subject: DROP COLUMN


> im new to this list and to the SQL language, id like to know if anyone
> knows how to drop a column from a SQL database,i currently have the
> following string: "ALTER TABLE WorkGroups DROP COLUMN Personnel"
> i read somewhere something about having to store the information in a
> temporary column before dropping it but cant rememebr where i read it, i
> get an error that says:Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
> near 'Personnel'.
> thanx regards wernher
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread65471@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-rhopkins=mail.waytech.com.tw@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
DROP COLUMNWernher Korff16 Feb
  • Re: DROP COLUMNRolf Hopkins19 Feb