1、创建视图

create view chl_view as select * from T_BD_ACCOUNT 

 create  view chl_view002 as select * from  chl_view 

create  view chl_view004 as  select a.facctid,b.fnumber,c.fdc from chl_view002 a join chl_view b on a.FACCTID=b.facctid join  T_BD_ACCOUNT c on a.FACCTID=c.FACCTID 

2、查询依赖关系

 exec sp_depends chl_view004

超棒！