How To Create Table in MS Access Using SQL
In this video, we look at how to create a table in MS Access using an SQL query instead of the Create Table user interface.
Using SQL can be advantageous as it allows you to programatically create a database. You can also recreate the table by copying and pasting the SQL query.
The structure of the query is like:
CREATE TABLE TABLENAME(
fieldname fieldtype (field length if applicable),
fieldname fieldtype (field length if applicable),
.
.
.
PRIMARY KEY (fieldname)
)