Delete a field from a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks.
 
DROP the field:

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