Insert New Column at a specific place

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

How to insert a new column in a Access table at a specific place using SQL

If I use the following instruction a got my new column at the end of table

ALTER TABLE Customer ADD COLUMN column2 LONGCHA

The result

column
column
column

I'd like the result folling result:
column
column
column

Thanks

Kleber Muffat
Campinas-Brazi
 
Hi,

Why would you need that?
The column position is not relevant.
You might instruct the UI container to reorder the columns as you want.
 
¤ Hi,
¤
¤
¤ How to insert a new column in a Access table at a specific place using SQL.
¤
¤ If I use the following instruction a got my new column at the end of table.
¤
¤ ALTER TABLE Customer ADD COLUMN column2 LONGCHAR
¤
¤ The result:
¤
¤ column1
¤ column3
¤ column2
¤
¤ I'd like the result folling result:
¤ column1
¤ column2
¤ column3
¤

I don't believe you can set the ordinal position in the table using Jet DDL. It's probably only
supported by DAO.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top