Joe - Why was SURROGATE KEY left out from ISO table design?

The lack of SURROGATE KEY causes lots of confusion and ultimately loss of productivity. Common practice in SQL Server development to make the SURROGATE KEY the PRIMARY KEY, the source of all trouble because it is not really the "PRIMARY KEY" just a meaningless integer identifier.

Example:

CREATE TABLE Products (
        ProductID INT SURROGATE KEY,
        ProductNumber char(12) PRIMARY KEY,
        Name nvarchar(100) NOT NULL UNIQUE,
        ListPrice DECIMAL (12,2) NOT NULL,
        Color varchar(10) );

Is there a hope of correcting this issue?

Thanks.

---

---

---

Kalman Toth Database & OLAP Architect SQL Server 2014 Database Design

New Book / Kindle: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2014