Modifying Existing Tables

When you want to make structural changes to existing tables, you use the same techniques that you used to create the table. In SQL DDL, you use the appropriate ALTER TABLE statement to modify a table, or the DROP TABLE statement to delete it. In DAO, you either append or delete a field from the Fields collection of a TableDef object, or delete the TableDef object from the TableDefs collection of the database.