What is an alternate way of checking View inside Database?

Posted by vishalneeraj-24503 on 7/1/2014 | Category: Sql Server Interview questions | Views: 1112 | Points: 40

Answer:

Write below query:-

select * from sys.views where object_id = object_id(n'[dbo].[vw_name]');

select count(*) from sys.views where object_id = object_id(n'[dbo].[vw_test]')

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What is the Difference between below queries? S ...

Next > : How to check if View is present in Database?

More Interview Questions by vishalneeraj-24503

Latest Interview Questions