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

You guys have indeed been great partners in aiding us with getting our mailings processed through your software and out the door.  I want to say we’ve been with you guys for at least 12 years now, if not longer.  Find something good you stick with it is how I see it.
P.H., Colorado Springs, CO