iamusingtheopensourcecmspimcore (http://www.PIM core.org )，which runs on a MySQL backend。
itusesfairlycomplicatedviewstorepresentobjectsandoneofthemhasbecomebrokenatsomestagewhenacolumninanothertablebeingreferencedb y eritrytointeractwithetableviasqlcommandsireceivetheerror 3360
view ' bar riste _ website.object _6' referencesinvalidtable (s ) or
column(s ) or function(s ) s ) or definer/invokerofviewlackrightstouse
蒂姆
iwouldliketosimplyupdatetheviewtoreferencetherenamedcolumns，butineedtoknowthecurrentstructureoftheviewbeforeistartpokingaroungaroulttttpoungroungaroum
but I receive the same error。
Thanks for your help in advance！
解决方案
select view _ definitionfrominformation _ schema.views
where table _ schema=' test ' andtable _ name=' v '；
use数据库名称
GO
EXEC sp_helptext viewName
or also a query like this:
选择table _ name as viewname，
view _ definitionasymdl/pfrominformation _ schema.views
whereyoucouldaddawheretoonlyretrieveoneview