This system procedure removes an existing binding between a database and a resource pool for purposes of tracking In-Memory OLTP memory usage. If there is no pool currently bound to the specified database, success is returned. When the database is unbound, the previously allocated memory for memory-optimized objects stays allocated to the previous resource pool. You need to restart the database to free up the allocated memory. Once a database is unbound from the resource pool, the binding resorts to the DEFAULT resource pool.
Applies to: SQL Server (SQL Server 2014 through current version).
The following code unbinds the database Hekaton_DB from the In-Memory OLTP resource pool it is bound to. If Hekaton_DB is not currently bound to a In-Memory OLTP resource pool, a message is given. The database must be restarted for the unbinding to take effect.