Hi Dominic.

>Does anyone know how to reorder columns in a table programatically?

As Nadya pointed out, there's no way to do this other than creating the correct structure and APPEND FROM the existing one. However, Stonefield Database Toolkit can automate this (and many other database maintenance issues) for you. For more information, check out www.stonefield.com.

Doug