Support 805.461.7300
Sales
Our Technology. Your Success.

Change the name and/or width 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

Just wanted to say THANKS!!!!!!! Great training session and I ran another list this afternoon, no issues!!!! You ROCK!!!! I am just so pleased with AccuZIP...Donna and Crissy are wonderful and everyone is so helpful! Very refreshing in these times!!! THANK YOU AGAIN!!!!
L.B., Englewood, FL