CREATE TABLE Employees ( ID INT PRIMARY KEY, Name VARCHAR(100), Department VARCHAR(50) );
CREATE CLUSTERED INDEX CX_Employees ON Employees (ID);
This is the better syntax. refer https://reloadbasics.com/sql/Clustered_Indexes_in_SQL for more info.