Question

in which mode we can change the mode of a database table​

Answer 1

Answer:

Right click on Database, select Properties. And in the Database Properties window, select Options page. In Options page, under State change Database Read Only value to False.

Answer 2

By default, all of them are in memory mode, but by the time, some of the became very huge and thus they eat all my (RAM) memory. I want to convert them to the "cached" mode, but I did not find any solution. However, it is very important not to get lost any existing data.