DROP TABLE IF EXISTS dbo.ClusteredColumnstoreIndexTest;
CREATE TABLE dbo.ClusteredColumnstoreIndexTest
(
[a] VARCHAR(200) DEFAULT 'a',
[b] VARCHAR(MAX) DEFAULT 'a',
[c] NVARCHAR(100) DEFAULT 'a',
[d] NVARCHAR(MAX) DEFAULT 'a',

[e] DATETIME,
[f] DATETIME2,
[g] DATE,
[h] TIME,
[i] DATETIMEOFFSET,

[j] TINYINT DEFAULT 1,
[k] SMALLINT DEFAULT 1,
[l] INT DEFAULT 1,
[m] BIGINT DEFAULT 1,

[n] DECIMAL(20,10),
[o] FLOAT,
[p] MONEY,

INDEX [CCI_ClusteredColumnstoreIndexTest] CLUSTERED COLUMNSTORE
);

INSERT INTO dbo.[ClusteredColumnstoreIndexTest] DEFAULT VALUES;

ALTER INDEX [CCI_ClusteredColumnstoreIndexTest] ON dbo.[ClusteredColumnstoreIndexTest] REBUILD;


SELECT css.[column_id], css.[encoding_type], css.[base_id], css.[magnitude]
FROM   sys.column_store_segments css
INNER JOIN sys.partitions prt
        ON prt.[hobt_id] = css.[hobt_id]
WHERE  OBJECT_NAME(prt.[object_id]) = N'ClusteredColumnstoreIndexTest'
ORDER BY css.[column_id];