Delete Field from Table

[Rjc8513]

How can I delete a field from an existing table?

I have combined the contents of fldA and fldB into fldB and now I want to remove fldA from the table.

Thanks.

 

[Golom]

ALTER TABLE myTable DROP COLUMN fldA

should do it unless the field is involved in a relationship or is part of the primary key in which case you first need to drop the relations and/or change the keys.

 

[easyit]

F1 and tabledefs should get you started

 

[Rjc8513]

Thanks Golom, that did it!

Here's the code that successfully deleted the field:

dbs.Execute "ALTER TABLE [myTable] " & _
"DROP COLUMN " & fldA & ";"