alter table - insert new column 1

[mrsbean]

I want to insert a new column after a specific column in a table. The database is used online, and I must use a query statement to alter the table. I have the syntax which will add a column to the database, but I want to take it one step further. I want to put the new column in a certain place in the table structure -- not just make it the last column in the table. Is this possible in Access?

The following code works -- adds the column. How do I change it to specify exactly where the new column should go?

ALTER TABLE table_order add column cc_cvs integer

MrsBean

 

[PHV]

You can't in JetSQL, but who cares the ordinal position of a column in a table ?
Don't you always use a query when you play with the data ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mrsbean]

Okay. I figured I couldn't do it the way I wanted. I'll just put it at the end of for now, and sometime when I have late night access to the server, I'll take it down for a few minutes and fix it ... I know it's probably nit picky and doesn't matter, but I want to put the column in order with other associated fields.

MrsBean

 

[PHV]

I want to put the column in order with other associated fields
Again, who cares in a RDBMS ?