EnterpriseDW
 PK_dbo.DimCompensationType (Index)
Home  Diagrams  Documents  Images  EnterpriseDW  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  EnterpriseDW   Tables   dbo.DimCompensationType   PK_dbo.DimCompensationType
  Properties
Property Value
Name PK_dbo.DimCompensationType
Index Key Type DriPrimaryKey
Is Clustered True
Is Full Text Key False
Is Unique True
Ignore Duplicate Keys False
Fill Factor 0
Space Used (KB) 16
Is Index On Computed False
Is Index On Table True
No Automatic Recomputation False
Filegroup PRIMARY
Description
  Columns
Name Computed
CompensationTypeSK
False
  Extended Properties
Object Property Value
  DDL
/****** Object: Index [PK_dbo.DimCompensationType] Script Date: 03/09/2017 17:15:25 ******/
ALTER TABLE [dbo].[DimCompensationType] ADD  CONSTRAINT [PK_dbo.DimCompensationType] PRIMARY KEY CLUSTERED 
(
    [CompensationTypeSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
Powered by BI Documenter