Access Alter Table: A Data Definition Query

Access Alter Table: A Data Definition Query

There are occasions when you may want to manipulate the structure of your database and in one example using the Access ALTER table to modify fields in a table without the hassle of going to the design area (under the hood) and physically change fields and their data types.

This is part of the Data Definition query series in MS Access and can only be built using the SQL view only as there is no design query grid (QBE grid) for your convenience.

The language and keywords required to change or modify a field in a table is as follows:

ALTER TABLE table_name ADD/DROP/ALTER column_name [datatype]

The ADD keyword will Continue reading “Access Alter Table: A Data Definition Query”