--0-250064411-980257716=:64353
Content-Type: text/plain; charset=us-ascii


I am not sure why you want to alter the position

of a column. However there are two ways 

One through SQL CREATE A TABLE WITH YOUR REVISED 

Column Order

Then Query Insert from the Old to the New

Drop the Old View

Rename New View

You can Use 

the ALTER TABLE  ADD Column   approach and

again update the New Column from the Old

Then drop the Old Column

Having said the above however Data and Hence Columns

are a matter of DESIGN not necessarily View. Sometimes

the Physical Data Design can be very different from Users

Perceptions and for very good reason. The Physical order

of columns should not dictate how that dat is used or Viewed.

Roland


  Michael Morisoli <Michael@M...> wrote: 
If you use Enterprise Manager to alter the structure of your tables, it
is very simple to do this. I don't know how to do it with SQL...




---------------------------------
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.