B
B
bodrich2016-06-20 20:32:18
SQL Server
bodrich, 2016-06-20 20:32:18

What is the difference between Sys.indexes and Sys.sysindexes in MS-SQL?

Actually, subject. What are their differences?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2016-06-21
@bodrich

msdn.microsoft.com :

sys.sysindexes (Transact-SQL)
Contains one row for each index and table in the current database. XML indexes are not supported in this view. Partitioned tables and indexes are not fully supported in this view. Use the sys.indexes catalog view instead.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question