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’m influenced and impressed by the AccuZIP support personnel you have. We had setup issues on Friday and I was jamming things through my mail department and wanted to be able to use AccuTrace THAT DAY. It was important for my client. As a result I phoned support and spoke to a wonderfully pleasant woman who was extremely knowledgeable, polite and helpful. Donna whom I believe lived in Georgia was the representative. She is a treasure.
T.R., San Luis Obispo, CA