The SQL Server Partition key column must be part of the primary key

The SQL Server Partition key column must be part of the primary key.

You must include the partition column in the key column of the primary key/UNIQUE constraint/unique index.

 UsetempdbGO--Test TableCREATE TABLEDBO.TB (IDint,    CONSTRAINTpk_idPRIMARY KEY CLUSTERED(ID))INSERTDBO.TBSELECT 1 UNION  AllSELECT TenGO--Switch to partitioned table--partition FunctionCREATEPARTITIONFUNCTIONPf_test (int) asRANGE Left for VALUES(5)--Partition ArchitectureCREATEPARTITION SCHEME ps_test asPARTITION pf_test All  to(    [PRIMARY])--switch to partition tableALTER TABLEDBO.TBDROP CONSTRAINTpk_id with(MOVE toPs_test (ID))

The SQL Server Partition key column must be part of the primary key