enrique_aeo
asked on
PRIMARY KEY NONCLUSTERED
Hi Experts,
I am creating a table for a datawarehouse bd, my question is: because the dimension tables must in PRIMARY KEY NONCLUSTERED
for example:
CREATE TABLE DimProduct
(ProductKey int identity NOT NULL PRIMARY KEY NONCLUSTERED,
ProductAltKey nvarchar(10) NOT NULL,
ProductName nvarchar(50) NULL,
ProductDescription nvarchar(100) NULL,
ProductCategoryName nvarchar(50))
GO
I am creating a table for a datawarehouse bd, my question is: because the dimension tables must in PRIMARY KEY NONCLUSTERED
for example:
CREATE TABLE DimProduct
(ProductKey int identity NOT NULL PRIMARY KEY NONCLUSTERED,
ProductAltKey nvarchar(10) NOT NULL,
ProductName nvarchar(50) NULL,
ProductDescription nvarchar(100) NULL,
ProductCategoryName nvarchar(50))
GO
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't see a question there. :)