Change table from columnstore to rowstore


(Ported from memsql-public-chat Slack channel)

Thomas Geselle [Oct 10th at 10:42 AM]
Hi guys! How do I change a table using columnstore to inmemory rowstore?

2 replies
Bhargava [26 days ago]
You can copy data from rowstore to columnstore or vice versa using insert into table_name select * from table_name but you can’t change one type of table to another (edited)

Thomas Geselle [26 days ago]
Ok thanks I will try that


After you copy data from the columnstore table to the rowstore table using INSERT…SELECT… then you can drop the old table and rename the new one to have the same name as the old one if you want, using

ALTER TABLE newtablename RENAME oldtablename;