Support 805.461.7300
Sales
NEW SITE. Our Technology. Your Success.

Change the name and/or width of a field

The comamand below will allow you to change the name of a field

ALTER TABLE ALIAS() RENAME COLUMN zipcode to zip

If you want to change the width of a field, here's a command that changes the ZIP field to a width of 10

ALTER TABLE ALIAS() ALTER COLUMN zip C(10)

« Back to Commands

While we have consistently been impressed with the level of assistance we receive through your online chat portal, Geoff has been more than helpful and great to work with on every issue we’ve come across. He is quick to diagnose and resolve the issues. He also has offered to instruction and information to prevent future issues. He has even guided us through some functions of Accuzip we had not previously been utilizing. I wanted to take a minute and give a huge shout out to Geoff.
T.A., Grand Rapids, MI