you do do it on a table by table basis.it's easy to create an in memory real sql database - just dont assign a folder item to it or try & create a folder item for it.This will create a db (named db) as an in memory database to which you can add tables etc.