Support 805.461.7300
Sales
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

I appreciate [AccuZIP support technician] Geoff! He has over and over with a positive attitude given us exceptional support. He is a key asset to us and we are so thankful for him. I just wanted to let you all know that he has so much patience and knowledge. I am sure you know but he is a KEEPER for your company.
K.P., Colorado Springs, CO