CHeryl Lets say you want to redefine MyCol TEXT 6 to MyCol TEXT 12
Lets say it appears in tables DAVID and CHERYL Let's say it appears in the computed column MyCompCol in both tables as MyCompCol=(MyCol&LastName) TEXT 20 Here are the steps: AUTOCHK the database and back it up -- Remove computed column definition temporarily in --CHERYL ALTER TABLE CHERYL ALTER COLUMN MyCompCol TO MyCompCol TEXT 20 --Temp rename MyCol to MyCol1 and change size in --CHERYL ALTER TABLE CHERYL ALTER COLUMN MyCol TO MyCol1 TEXT 12 -- Remove computed column definition temporarily in --DAVID ALTER TABLE DAVID ALTER COLUMN MyCompCol TO MyCompCol TEXT 20 --Do the permanent redefine in DAVID ALTER TABLE DAVID ALTER COLUMN MyCol TO MyCol TEXT 12 -- Put back computed col definition in DAVID ALTER TABLE DAVID ALTER COLUMN MyCompCol to MyCompCol=(MyCol&LastName) TEXT 20 --Rename back to original name in CHERYL ALTER TABLE CHERYL ALTER COLUMN MyCol1 TO MyCol TEXT 12 --Put back computed col definition in CHERYL ALTER TABLE CHERYL ALTER COLUMN MyCompCol to MyCompCol=(MyCol&LastName) TEXT 20 Now you'll need to PACK the database, check it again and back it up. David Blocker ----- Original Message ----- From: "McClure, Cheryl" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, July 16, 2003 12:51 PM 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 > >
