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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2010-10-13 : 16:11:41
|
| What is the SQL query to list all the Indexed Views in a DB?------------------------I think, therefore I am - Rene Descartes |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2010-10-14 : 01:29:24
|
select so.name,si.name as IndexNamefrom sys.indexes sijoin sys.objects so on so.object_id=si.object_idwhere so.type='V'
elsasoft.org |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2010-10-14 : 09:21:27
|
| Thank you, jezemine.------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
Query to list the Indexed Views in a DB