Altering the database to use a new template

Adaptive Server does not change a database’s existing data when you use alter database to change the template. Adaptive Server uses data from the new template to re-create the database when you restart Adaptive Server.

You can change the template only for in-memory databases and for databases that use a durability of no_recovery; you cannot change the templates for system or traditional disk-resident databases using full durability.