Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gregoryagu
Yak Posting Veteran
80 Posts |
 Posted - 2008-07-24 : 18:45:57
|
| What is the difference between sys.indexes and sysindexes?When should one be used, and when should the other be used?Greg |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-24 : 18:54:00
|
| You should be using sys.indexes for SQL Server 2005. sysindexes is provided for backwards compatibility, such as for code that was written for SQL Server 2000.This is mentioned in SQL Server Books Online, so be sure to check there first.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-25 : 00:17:52
|
| refer this article for getting the entire list of new system views that correspond to old system tableshttp://msdn.microsoft.com/en-us/library/ms187997.aspx |
|
|
|
gregoryagu
Yak Posting Veteran
80 Posts |
Posted - 2008-07-25 : 12:43:01
|
| OK thanks, and got it on checking BOL first.Greg |
|
|
|
|
|
|
sys.indexes vs sysindexes