Object_id wild card

[manmaria]

By executing this command

SELECT * FROM sys.views where object_id = OBJECT_ID(N'[dbo].[MyView]')

I can find the details about MyView. Is there way I can find all the views like MyV% ?

I can do this

SELECT * FROM sys.views v inner join sys.objects o on v.object_id=o.object_id WHERE
o.name like 'MyV%'

But, like to find anyother way to find list of views.

TIA

 

[gmmastros]

Select * 
From   Information_Schema.Tables 
Where  Table_Type = 'VIEW'
       And Table_Name Like 'MyV%'

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom