ALTER TABLE syntax (Access 97 SR-2)

Topic

New Reply

Right now I have a query like this:
ALTER TABLE MyTable ADD COLUMN MyColumn Number;

This adds a column named MyColumn whose data type is Number and whose field size is Double. (Double is evidently the default.) I want to specify “Long Integer” but I can’t seem to get the syntax right. Can anyone show me how to do this?

Reply | Quote

Replies

Use :
ALTER TABLE MyTable ADD COLUMN MyColumn Long;

Reply | Quote

Thanks! I just ran the query and it worked. Of course I thought I *had* tried that one, but obviously I must have mis-typed something. I appreciate the help.

Reply | Quote