2714739 - Incorrect syntax creating a clustered columnstore index - SAP PD

• PD generates an incorrect syntax to create a clustered columnstore index in Microsoft SQL Server.
• It misses the CLUSTERED keyword and the parentheses enclosing the list of index columns causes an error.
• PD generates:

CREATE COLUMNSTORE INDEX index_name ON schema_name.table_name ()
go

whereas the correct syntax is:

CREATE CLUSTERED COLUMNSTORE INDEX index_name ON schema_name.table_name
go

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• SAP PowerDesigner (PD) 16.6
• Microsoft SQL Server

MSS, non-clustered, 817302, CR817302, CR#817302 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed