ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Windows & Network Issues >> General Windows & Network Issues >> Database Tables
http://www.istechforum.com/YaBB.pl?num=1219427933

Message started by Kelloggs on 08/22/08 at 10:58:53

Title: Database Tables
Post by Kelloggs on 08/22/08 at 10:58:53

Here is a list of very "Suspicious" tables.

TESTFILE
TEMPOLD
SUMWC
SUMPNCUS
SUMCUST
SUMINV
UMCDATA
WBTRVMEM (doesn't even open)
WBTRVMEMO (doesn't even open)
XXICMSTR
BKGLTMP1
BKGLTMP2
BKGLTMP3
BKGLTMP5

Can I delete this tables? I dont think DBA/EVO create them.

Regards,

Kelloggs

Title: Re: Database Tables
Post by NovaZyg on 08/22/08 at 12:38:36

Some of those are good.. Wbtrvmem.b and WbtrvMemo.B are the Evo Notes. BKGLTMP1-5 are files used by GL posting.
XXICMSTR is a copy of BKICMSTR it is unused but it is a DBA/Evo Standard file and we may use it someday. Same goes for the SUM* files. Testfile is in my dictionary too, but never used, same with tempold.

So out of your list only UMCDATA could be erased. The rest would just be recreated the next time you run update, if you deleted them, and you would potentially lose data (Notes)