select
视图名=object_name(id),
相关表名=object_name(depid),
对应字段名=(select name from syscolumns where id=depid and colid=depnumber)
from sysdepends where objectproperty(id,'IsView')=1
order by id
视图名=object_name(id),
相关表名=object_name(depid),
对应字段名=(select name from syscolumns where id=depid and colid=depnumber)
from sysdepends where objectproperty(id,'IsView')=1
order by id
(ID, LICENSEID, MANUCORPNAME, MEDICINENAME, MAKEPERMITNO, MAKEDATE, EFECTTERM, QUANLITY, UNIT, SPEICAL, REMARK, PERMITNO, QUANSTANDARD, CHECKOUTNO, FORBIDMEMO, REGIONID, MEMO, TRANID, SALEDATE, CORPORATIONNAME) AS
select t_mpm_salerecord.*,
t_mpm_license.corporationname
from t_mpm_license,
t_mpm_salerecord
where t_mpm_license.id = t_mpm_salerecord.licenseid通过zjcxc的方法,查不到表t_mpm_salerecord,只能看到这个视图对表t_mpm_license 的引用