What is an alternate way of checking View inside Database?

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

Write below query:-
select * from sys.views where object_id = object_id(n'[dbo].[vw_name]');

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


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response