7
Reply

Can I create Clustered index without Primary key?

Sandy

Sandy

Oct 27, 2017
1.1k
0

    Primary key does not allow NULL, where in clustered index allow NULLs. Clustered index without primary key creates an Unique, PRIMARY KEY NONCLUSTERED index on the table

    rohit keshari
    November 01, 2017
    2

    Yes, you can create. The main criteria is that the column values should be unique and not null. Indexing improves the performance in case of huge data and has to be mandatory for quick retrieval of data.

    Vinod Ramakrishnan
    December 17, 2017
    1

    Yes, You can but make sure value should be unique and not nul

    Amit Nagar
    November 22, 2017
    1

    http://blog.ithubcity.com/details/sql-server/sql-server/8/154/can-we-create-clustered-indexes-without-primary-key-and-none-clustered-index-with-primary-key?

    Paul
    October 31, 2017
    1

    Primary key is a constraint and clustered index is an index so, logically they are both different entities in RDBMS. As a matter of fact, this is possible in one condition, when clustered index is created before the primary key on the table otherwise primary key will by default create the clustered index with it and only one clustered index is allowed per table.

    Nikunj Satasiya
    December 22, 2017
    0

    No

    Neha Kumari
    November 05, 2017
    0

    yes

    Ankur Mistry
    October 31, 2017
    0