List:General Discussion« Previous MessageNext Message »
From:Wernher Korff Date:February 16 2001 10:20am
View as plain text  
hello list;)

i have a SQL command to DROP a COLUMN from a mySQL database, the problem
is that the syntax i am using doesnt seem to be the right syntax for
mySQL, my statement currently read:"ALTER TABLE WorkGroups DROP COLUMN
Personnel" and i get the error message:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near 'Personnel'.
please help

thanx regards wernher

DROP COLUMNWernher Korff16 Feb
  • Re: DROP COLUMNJeremy D. Zawodny18 Feb