|
For a column (or field), the syntax is not DROP COLUMN but just DROP. You can then add a list of fields to drop all at once. Other operations, such as DROP INDEX, do take an extra token. [Edit] I half put you crook. Yes, just DROP. But you must repeat DROP for each field to be removed (with commas in between). A bare list of fields to drop is not valid. So ALTER TABLE [Customers] ( DROP [Name], DROP [address], … ) ; If that is not convenient, you might prefer to SELECT INTO a new table.
|