Get A List Of Views From Linked Server Database -

i trying execute syntax if view exists. code, keeps underlining line saying must declare variable @vn -- aren't declaring in line above?

further insight, #tbl_views spreadsheet imported, contains listing of possible views, view may or may not exist. wanting check if view exists before querying it, hence if statement.

declare @vn varchar(max)  --more stuff here  while @count > 0   set @vn = (select top 1 viewname #tbl_views)  if exists (select * @vn)    begin     --if view exists, let's query it.     --if view not skip , move on next   end  set @count = @count - 1 

edit --- no longer producing compile error code above, how can check view on different server server running query on? example, query run on superfly , need see if view exists on leonardo

if exists(select * sys.views name = @vn) 

edit # 2 using syntax -- , yes linked server connection

if exists(select * leonardo.production.sys.views name = @vn) 

produces error:

msg 7314, level 16, state 1, line 321 ole db provider "sqlncli10" linked server "leonardo" not contain table ""production"."sys"."views"". table either not exist or current user not have permissions on table.

your setting @vn = ( select top 1 viewname #tbl_views)

from understanding of question understanding of sql. you'll have have following code @ top of query:

declare  @vn datatype set @vn = ( select top 1 viewname #tbl_views) 

you try:

declare      @vn datatype = ( select top 1 viewname #tbl_views) 

hope helps!