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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
