Delete a field from a table

T

TommoUK

I'm trying to programatically remove a field from a table. Does anyone know a
quick solution?

Thanks.
 
A

Allen Browne

DROP the field:

Dim strSql As String
strSql = "ALTER TABLE [MyTable] DROP COLUMN [MyField];"
DBEngine(0)(0).Execute strSql, dbFailOnError
 
Top