I wish I could have been there, but unfortunately work intervened and I needed to be in Memphis.
Emmitt Dove Manager, Converting Applications Development 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 jan johansen Sent: Tuesday, October 19, 2010 15:38 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Changing a column width in many tables Emmitt, Thanks for the correction. Missed your smiling face at the conference. Jan -----Original Message----- From: "Emmitt Dove" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 19 Oct 2010 15:35:36 -0400 Subject: [RBASE-L] - Re: Changing a column width in many tables ALTER TABLE Table2 ALTER COLUMN CompName2 TO CompanyName TEXT (50) NOCHECK Emmitt Dove Manager, Converting Applications Development 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 jan johansen Sent: Tuesday, October 19, 2010 15:23 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Changing a column width in many tables Les, Assume you wish you change the column CompanyName from 40 to 50 and it exists in 4 tables. RENAME CompanyName TO CompName2 IN Table2 NOCHECK RENAME CompanyName TO CompName3 IN Table3 NOCHECK RENAME CompanyName TO CompName4 IN Table4 NOCHECK ALTER TABLE Table1 ALTER CompanyName TEXT 50 NOCHECK ALTER TABLE Table2 ALTER CompName2 TEXT 50 NOCHECK ALTER TABLE Table3 ALTER CompName3 TEXT 50 NOCHECK ALTER TABLE Table4 ALTER CompName4 TEXT 50 NOCHECK RENAME CompName2 TO CompanyName IN Table2 NOCHECK RENAME CompName3 TO CompanyName IN Table3 NOCHECK RENAME CompName4 TO CompanyName IN Table4 NOCHECK I think there is a way to combine the ALTER and NAME at the same time but can't think of the syntax. Hope this helps. Jan -----Original Message----- From: Les Stark <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 19 Oct 2010 14:02:13 -0500 Subject: [RBASE-L] - Changing a column width in many tables Is there a simple way to change the width of a column that appears in many tables without renaming each column in each table? Perhaps using the sys tables? --
