|
Posted by Glenn Adams [MVP - Retail Mgmt on May 16, 2006, 1:27 pm
Please log in for more thread options
That's not a table.
It's a VIEW, which is sort of a stored query. A view does not contain
actual records - it is a query that returns records from other table(s).
The best place to start reclaiming space is usually the journal table.
I believe there are Knowledge Base articles on archiving available on
Customer Source and Retail Realm has an archiving utility that will take
care of it for you.
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.
HankSmart wrote:
> My database is getting rather large and I am deleteing old records. There is
> one table, VIEWITEMMOVEMENTHISTORY, that has numerous records but when I try
> to delete the old records I get the error: UNION ALL view
> 'VIEWITEMMOVEMENTHISTORY' is not updatable because the definition contains a
> disallowed construct.
>
> Does anyone know how to go about deleteing the records from this table?
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap