If you are going to use this method, I would do it in 2 steps. With this method you don't have the problem of your file being too big for the editor.
con cbname out mydb.sch unload schema out mydb.dat unload data out screen rbe mydb.sch edit out funky table. rename your original db to something else disconnect run mydb.sch run mydb.dat you will see some error messages when it tries to load the funkey table that you edited out of the sch file. Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dan Goldberg Sent: Thursday, June 19, 2003 4:35 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SYS_TABLES TABLE Thanks for the tip. I will give it a try!! I was almost getting ready to punt!! Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rommel Relosa Sent: Thursday, June 19, 2003 3:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SYS_TABLES TABLE Dan, If you don't have RScope (yet <g>), you can try this to remove the funky table. CONNECT <DBNAME> OUTPUT UNLOAD.DAT UNLOAD ALL OUTPUT SCREEN Now, if the file is not too big, use a text editor and look for the CREATE TABLE `funkyname` entries and remove it. Then, look for the section with LOAD funkyname and delete the "load" entries. Rename the database (back up purposes, in case reload fails <g>) then issue: INPUT UNLOAD.DAT This will rebuild the database without the table with the funkyname. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dan Goldberg Sent: Thursday, June 19, 2003 1:51 PM To: RBASE-L Mailing List Subject: [RBASE-L] - SYS_TABLES TABLE Does anybody know how to edit the sys_tables table?? I have a table that has a funky name that I can not get a rid off. Dan Goldberg
