DWStaging
 U3U7M15SN3XD9 (Index)
  Properties
Property Value
Name U3U7M15SN3XD9
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) 104
Is Index On Computed False
Is Index On Table True
No Automatic Recomputation False
Filegroup PRIMARY
Description
  Columns
Name Computed
ISN_FAC193_ROOM_A
False
cnxarraycolumn
False
  Extended Properties
Object Property Value
  DDL
/****** Object: Index [U3U7M15SN3XD9] Script Date: 03/09/2017 16:54:38 ******/
CREATE UNIQUE NONCLUSTERED INDEX [U3U7M15SN3XD9] ON [dbo].[FAC193_ROOM_A_ROOM_USE_DATE_CODE] 
(
    [ISN_FAC193_ROOM_A] ASC,
    [cnxarraycolumn] 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