查询视图对应的基表名以及视图字段和对应的基表字段名
转:https://blog.csdn.net/weixin_33845477/article/details/93364024
select v.name ViewName,t.name TableName,vc.name ViewCol,tc.name TableCol
from sysdepends d,
sysobjects v,
syscolumns vc,
sysobjects t,
syscolumns tc
where objectproperty(...
转载
2020-09-23 17:07:23 ·
2256 阅读 ·
0 评论