Impact of Gen-AI on IT Jobs - Growth Mindset Show
x
C# Corner
Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
.NET
ADO.NET
Android
ASP.NET
C#
Databases & DBA
Design Patterns & Practices
iOS
Java
OOP/OOD
SharePoint
Software Testing
Web Development
WPF
View All
7
Reply
Can I create Clustered index without Primary key?
Sandy
8y
1.2k
0
Reply
Delete Row
Delete Column
Insert Link
×
Insert
Cancel
Embed YouTube Video
×
Width (%)
Height (%)
Insert
Cancel
Table Options
×
Rows
Columns
First row as header
Create Table
Insert Image
×
Selected file:
Alignment
Left
Center
Right
Select an image from your device to upload
Upload to Server
Cancel
Submit
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
8y
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
7y
1
Yes, You can but make sure value should be unique and not nul
Amit Nagar
8y
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
8y
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
7y
0
No
Neha Kumari
8y
0
yes
Ankur Mistry
8y
0
Message