CODEWITHSUNDEEP
sqlms-access
J. Doe
J. Doe

Reputation: 199

MS Access ALTER TABLE

I am trying to add a column to an existing table. here is what I have.

ALTER TABLE [test] ADD COLUMN test_column int();

I am getting this error. "Syntax error in ALTER TABLE statement"

Upvotes: 0

Views: 496

Answers (1)

Aaron Dietz
Aaron Dietz

Reputation: 10277

Remove the parentheses ()

ALTER TABLE [test] ADD COLUMN test_column int;

Parentheses are used for string datatypes with variable lengths or datatypes with precision and scale. int is a set length.

Upvotes: 1

Related Questions