DWStaging
 U2F62B37P0IWIG (Index)
Home  Diagrams  Documents  Images  DWStaging  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:  DWStaging   Tables   dbo.ATTENDANCE_REQUEST_A_ATT_ADJUSTMENT_IND   U2F62B37P0IWIG
  Properties
Property Value
Name U2F62B37P0IWIG
Index Key Type None
Is Clustered False
Is Full Text Key False
Is Unique True
Ignore Duplicate Keys False
Fill Factor 0
Space Used (KB) 203600
Is Index On Computed False
Is Index On Table True
No Automatic Recomputation False
Filegroup PRIMARY
Description
  Columns
Name Computed
ISN_ATTENDANCE_REQUEST_A
False
cnxarraycolumn
False
cnxarraycolumn_2
False
  Extended Properties
Object Property Value
  DDL
/****** Object: Index [U2F62B37P0IWIG] Script Date: 03/09/2017 16:51:29 ******/
CREATE UNIQUE NONCLUSTERED INDEX [U2F62B37P0IWIG] ON [dbo].[ATTENDANCE_REQUEST_A_ATT_ADJUSTMENT_IND] 
(
    [ISN_ATTENDANCE_REQUEST_A] ASC,
    [cnxarraycolumn] ASC,
    [cnxarraycolumn_2] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
Powered by BI Documenter