with Table_analysis (View_Name , level )
as (
	select view_name, 0 as level 
             from information_schema.view_table_usage 
             where table_name = @Table_Name
	   union all
	select vtu.view_name, level + 1 as level 
             from information_schema.view_table_usage vtu 
             inner join Table_analysis ta 
             on ta.View_Name = vtu.table_name
	)
select * from Table_analysis
order by view_name
go