Cheryl, You want to re-name the columns, then redefine them and then rename them back to the original name. You should also use the nocheck option on the rename if you are going to wind up having the col back to the original name. That eliminates the overhead of R:base updating your forms and reports.
Example. You have mycol type text 4 in 3 tables. I am doing this on the fly so my syntex may not be exactly right, but here goes. rename mycol to mycol1 in table1 nocheck rename mycol to mycol2 in table2 nocheck rename mycol to mycol3 in table3 nocheck redefine your columns with the ALTER TABLE command rename mycol1 to mycol in table1 nocheck rename mycol2 to mycol in table2 nocheck rename mycol3 to mycol in table3 nocheck Good Luck, Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of McClure, Cheryl Sent: Wednesday, July 16, 2003 10:52 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Redefining column when column exists in multiple tables Running current Windows 6.5 version of R:BASE: I need to change a text column in a table from 6 characters to 12 characters. This column appears in more than one table and is used in a computed column. I know there is some sort of round robin type method to change the column, but the details have slipped my mind. Could someone refresh me please? Thanks! Cheryl McClure CDC
