I want to write an update program to update a table one of my products and i need to add a field between field 4 and 5,How?
i write this code but it add that field at the bottom of fields :

Alter Table contacts Add cdate c(10)