Sql-docs: "columnstore table does not allow a primary key constraint" is false?

[samrueby]

This documentation states "By design, a columnstore table does not allow a primary key constraint."

This doesn't appear to be true. See this example:

CREATE TABLE t_account (
AccountKey int NOT NULL PRIMARY KEY NONCLUSTERED,
AccountDescription nvarchar (50),
AccountType nvarchar(50),
UnitSold int
);

CREATE CLUSTERED COLUMNSTORE INDEX t_account_cci ON t_account ;

This executed fine in SQL 2017. I think what the documentation intends to say is that the table cannot have a clustered primary key, since the table is a clustered columnstore index.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 3e021430-b8b5-1a96-1e71-c95d72580c0f
• Version Independent ID: 9f8a8520-31ef-eb8f-3ff5-c92db7d69514
• Content: Columnstore indexes - Data Warehouse - SQL Server
• Content Source: docs/relational-databases/indexes/columnstore-indexes-data-warehouse.md
• Product: sql
• Technology: table-view-index
• GitHub Login: @MikeRayMSFT
• Microsoft Alias: mikeray

[WilliamAntonRohm]

@samrueby -- Sam, thank you for your feedback and your researches.

@MikeRayMSFT -- please look into this issue 3938.

[MikeRayMSFT]

@samrueby - thanks for the submission. Verifying.

[pmasl]

Fixed by adding "clustered". Does not allow a clustered PK.