Search code examples
monetdb

monetdb: Online Schema Alters


Does MonetDB support online schema changes? For example adding/changing a column on the fly while the tables are loaded in memory. Many in-memory databases have to restarted to get the schema changes reflected. So, I was wondering if MonetDB took care of this issue.


Solution

  • Yes. MonetDB supports SQL-99 which includes DDL statements (that are immediately reflected in the schema).