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

I can't believe how excellent your support is. The last disaster you rescued me from was one that a programmer had told me had no answer that he knew of. Well, you know more than him! I e mail ed you on a SATURDAY and you had the problem solved by Monday morning!
C.P., Houston, TX