ADD COLUMN in a specified position?

[Zoon]

Can I add a column to a jet 3.5 database in a specified column position using SQL?

I tried the following and they did not work; ALTER TABLE [Products] ADD COLUMN [New Things] TEXT(20) BEFORE [Entered Date], ALTER TABLE [Products] ADD COLUMN [New Things] TEXT(20) AFTER [Description].

This works but it puts New Things in as the last column; ALTER TABLE [Products] ADD COLUMN [New Things] TEXT(20).

 

[JeremyNYC]

Why do you care about the position of the column? I would say that relying on the position of a column in a database is a dangerous thing to do.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.