Microsoft Access Database Development With VBA

SQL Keywords: ALTER

   

Introduction

The ALTER keyword is used to modify the structure of a table. It can be used to add a new column to an existing table. The formula to use would be:

ALTER TABLE TableName
ADD COLUMN ColumnName DataType

Here is an example:

ALTER TABLE Employees ADD COLUMN EmailAddress Text(100);
     
 

Home Copyright © 2011 FunctionX, Inc. Home