# 4733 Dropping or Renaming a Database with Statement/Procedure Caching Enabled Can Cause AV

---

Dropping an in memory database without specifying "KEEP CONTENTS" in a session with SQL Statement Caching enabled throws an error.

Steps to reproduce:

1. Open a session with SQL Statement Caching enabled and create an in memory database:

CREATE DATABASE "TestMemDB" IN MEMORY UNENCRYPTED CATALOG

2 Open the database and create a table:

CREATE TABLE "TestTable" ("TestField" SMALLINT)

3. run the following query:

select * from testtable where testfield is not null

4. Close the database without closing the session, and then drop the database:

DROP DATABASE "TestMemDB"


The resulting error depends on if it's a local or remote session:

Local: Access violation at address 0057822C in module 'edbmgr.exe'. Read of address 00000004"

Remote: ElevateDB Error #300 Cannot lock the database TestMemDB for exclusive access