How do I delete table column only using a query?

[Guest]

How do I delete a table column by using a query, not in table view(design or
othewise). I want to put this query in a macro.
Thanks

 

[Allen Browne]

RunSql on a query statement like this:

ALTER TABLE [MyTable] DROP COLUMN [MyField];

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Rick B]

Not sure you can. Why would you want a query to modify your table design -
especially to delete a column?

 

[Guest]

You can not.

You can delete the data in a field by using an update query.