ALTER TABLE: insert a field and specify location of new field
I have an existing table with several fields. I want to alter the table to insert a new field in a specific location, say, after the third existing field. Is there a way to specify on the add where the new field is put? Thanks.