It's not ALTER TABLE.
RENAME COLUMN transid TO transxno IN transmaster
You can globally rename the column by leaving off "IN transmaster"
Albert
jan johansen wrote:
Karen/Gunnar,
Thanks for the information.
Now in order to re-type, I need to re-name.
I've tried several itterations of the ALTER TABLE command and just
haven't gotten
it right yet.
What is the syntax to ALTER a column name?
Jan
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
