SqlDbx
You are not logged in.
Pages: 1
When scripting a table with a column store index, it is building the DDL as a regular index, example:
From SqlDbx 6.04:
CREATE INDEX [NonClusteredColumnStoreIndex-20191114-075458]
ON cw.ActiveDayServed (orkidsid, Date_Served)
WITH (ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)
GO
From SSMS 18.7.1:
/****** Object: Index [NonClusteredColumnStoreIndex-20191114-075458] Script Date: 1/25/2021 8:22:57 AM ******/
CREATE NONCLUSTERED COLUMNSTORE INDEX [NonClusteredColumnStoreIndex-20191114-075458] ON [cw].[ActiveDayServed]
(
[orkidsid],
[Date_Served]
)WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO
Thank you for your attention to this issue.
Offline
Pages: 1