Does dropping clustered index also drop the primary key on the same column? Here is the short answer, a follow-up to last week’s question on the reverse case.
Does Dropping Primary Key Drop Clustered Index on the Same Column? – Interview Question of the Week #082
When you drop a primary key, does it drop the clustered index on the same column too? Yes, it does. Here is a small script that shows it.
Can We Have NULL Value in Primary Key? – Interview Question of the Week #075
Can we have a NULL value in primary key columns? No. The primary key has to uniquely identify each row, and NULL cannot do that. Here is why.
What is NOT NULL Constraint? – Interview Question of the Week #073
A client table full of NULL values was hurting query plans. Here is what a NOT NULL constraint is, how to add one and why it helped performance.
Primary Key and Null in SQL Server – Interview Question of the Week #071
Can a primary key contain NULL values? No. Here is why primary key and NULL do not mix, and the simple interview question many candidates miss.
SQL SERVER – Identify Table Where Clustered Index is Not a Primary Key – DMV
Let us first see script which will return us tablename with schema where clustered index is not a primary key.
Interview Question of the Week #062 – How to Find Table Without Clustered Index (Heap)?
Not every table has a clustered index. Here is a quick script to find each table without a clustered index, also called a Heap, in your database.