query to find all indexed views in a database?select name from sysobjects
where objectproperty(id, 'isindexed')=1
and xtype='V'
--
-Vishal
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O508GIIWDHA.1896@.TK2MSFTNGP12.phx.gbl...
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment