There are two commands to drop cache bindings:
sp_unbindcache unbinds a single entity from a cache.
sp_unbindcache_all unbinds all objects bound to a cache.
sp_unbindcache dbname [, [owner. ] tablename [, indexname | “text only”] ]
To drop the cache binding of database 'sales':
sp_unbindcache 'SALES'
When you drop a cache binding to an object, all the pages currently in memory are cleared from the cache.
You cannot run sp_unbindcache_all on a named cache when there are system or remote local temporary databases bound to the cache. Instead, use sp_unbindcache to unbind each of these databases first, then run sp_unbindcache_all.
