Jan, You will want to rename that column to something else globally. RENAME Colname to Colnamex NOCHECK
Then for each table ALTER TABLE ALTER COLUMN Colnamex to Colname datatype etc Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Tuesday, June 15, 2010 10:55 AM To: RBASE-L Mailing List Subject: [RBASE-L] - SV: Column Re-Typing 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
