Use drop database to remove an in-memory database. This example drops the pubs6 database:
drop database pubs6
Dropping an in-memory database removes the database from the system tables, and relinquishes the in-memory storage cache, although the buffers and data in these devices remain. Dropping an in-memory database does not affect the in-memory storage cache on which it was created, which can be used for other in-memory databases.
