Primary Key and Database Size

Why does inclusion of a PK in each table of a database help to reduce the overall size of the database?

I had a trial database with lots of tables, one I put in PKs for every table, the size of the database shrank

Sanjay
kalraniAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
If there is NO primary key, SQL Server will take internally the entire record columns to identify the rows, which does take of course much more space that a single column...

CHeers
0
All Courses

From novice to tech pro — start learning today.