<div>
They could be constraints, not indexes.
</div>


<div>
Everything with _Sys_ is usually hidden and in use by the databaseprogram itself(SQL). <br />
<br />
Under MS access you don't see these system objects, but you can 'unhide' them to check their contents. (If you have Access just check the System Objects in the Tools/Options panel (Under the View tab). You will see the MSys... tables.
</div>


Everything with _Sys_ is usually hidden and in use by the databaseprogram itself(SQL).

Under MS access you don't see these system objects, but you can 'unhide' them to check their contents. (If you have Access just check the System Objects in the Tools/Options panel (Under the View tab). You will see the MSys... tables.

<div>
I think that they are statistics rather than indexes. They are created automatically when you have auto update statistics enabled.
</div>


I think that they are statistics rather than indexes. They are created automatically when you have auto update statistics enabled.

<div>
When I am selecting all the indexes, this too is getting selected. What I can I do to avoid these (bogus) indexes from getting selected?
</div>


When I am selecting all the indexes, this too is getting selected. What I can I do to avoid these (bogus) indexes from getting selected?

<div>
Within Access the only way to exclude them (when selecting each item of the table collection) is the explicit test for found items starting with the &quot;MSys&quot; characters and ignore them for further processing.<br />
&nbsp;
</div>


Within Access the only way to exclude them (when selecting each item of the table collection) is the explicit test for found items starting with the "MSys" characters and ignore them for further processing.
 

<div>
<div class="content wysiwyg-content">
I have seen some indexes begining<br />
with &quot;_WA_Sys_&quot;. I tried to drop them, and I got the error &quot;index is not present&quot;.<br />
<br />
What are these indexes?<br />
<br />
Thanks<br />
Srikumar<br />

</div>
</div>


I have seen some indexes begining
with "_WA_Sys_". I tried to drop them, and I got the error "index is not present".

What are these indexes?

Thanks
Srikumar


Index with names _WA_Sys_

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.