DWOperations
 ncidx__ST_STDNT_CLS_LOG__ArchivedEnrollmentSS_Extract__STDNT_ID__EFF_TRM__REF_NUM (Index)
Home  Diagrams  Documents  Images  DWOperations  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:  DWOperations   Tables   dbo.ST_STDNT_CLS_LOG__ArchivedEnrollmentSS_Extract   ncidx__ST_STDNT_CLS_LOG__ArchivedEnrollmentSS_Extract__STDNT_ID__EFF_TRM__REF_NUM
  Properties
Property Value
Name ncidx__ST_STDNT_CLS_LOG__ArchivedEnrollmentSS_Extract__STDNT_ID__EFF_TRM__REF_NUM
Index Key Type None
Is Clustered False
Is Full Text Key False
Is Unique False
Ignore Duplicate Keys False
Fill Factor 0
Space Used (KB) 0
Is Index On Computed False
Is Index On Table True
No Automatic Recomputation False
Filegroup PRIMARY
Description
  Columns
Name Computed
STDNT_ID
False
EFF_TRM
False
REF_NUM
False
  Extended Properties
Object Property Value
  DDL
/****** Object: Index [ncidx__ST_STDNT_CLS_LOG__ArchivedEnrollmentSS_Extract__STDNT_ID__EFF_TRM__REF_NUM] Script Date: 03/09/2017 17:22:31 ******/
CREATE NONCLUSTERED INDEX [ncidx__ST_STDNT_CLS_LOG__ArchivedEnrollmentSS_Extract__STDNT_ID__EFF_TRM__REF_NUM] ON [dbo].[ST_STDNT_CLS_LOG__ArchivedEnrollmentSS_Extract] 
(
    [STDNT_ID] ASC,
    [EFF_TRM] ASC,
    [REF_NUM] 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