DROP DATABASE IF EXISTS mcol5164; CREATE DATABASE mcol5164; USE mcol5164; CREATE TABLE t1(col1 INT, col2 VARCHAR(64)) ENGINE=Columnstore; SELECT * FROM t1; col1 col2 TRUNCATE t1; SELECT * FROM t1; col1 col2 11 test11-good TRUNCATE t1; SELECT * FROM t1; col1 col2 11 test11-good DROP DATABASE mcol5164;