Mike,
The simplest way is to write a script to make the changes. You can rename and resize the column in one step, then name it back: Assuming the old column is "columname" and it is TEXT (8): ALTER TABLE tablename ALTER COLUMN columname TO newcolumn TEXT (20) ALTER TABLE table2 ALTER COLUMN columname TO newcolumn TEXT (20) . for all the tables where it appears Then: ALTER TABLE tablename ALTER COLUMN newcolumn TO columname TEXT (20) ALTER TABLE table2 ALTER COLUMN newcolumn TO columname TEXT (20) . for all the tables. Notes: 1) If the column appears in forms, you will want to add the NOCHECK option to the ALTER TABLE commands to avoid having R:BASE go through every form each time you execute one. 2) MAKE A COPY OF THE DATABASE FIRST! Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of mike epstein sony viao office Sent: Saturday, November 08, 2008 11:15 AM To: RBASE-L Mailing List Subject: [RBASE-L] - changing the length of a text column common to other tables Good Morning, It was a pleasure to put faces with names at the recent convention in Pittsburg. I am trying to change the length of a text value column in a database where there are prox 10 tables which contain the identical column name . It seems that all of the tables must be changed simultaneously. Any ideas out there? Mike Epstein (Joe the plumbers distant cousin)
