what is difference between primary key and clustered index?
A clustered index stores all columns at the leaf level. ... A table without a clustered index is called a heap. A primary key is a unique index that is clustered by default. By default means that when you create a primary key, if the table is not clustered yet, the primary key will be created as a clustered unique index.