查询数据库时要先确定列表所在的内容数据库.
选定内容数据库后,执行以下sql语句
select
t.tp_title,t.tp_id
as
listid,a.tp_id
as
viewid,a.tp_displayname
from AllLists t,WebParts a
where t.tp_Title like N ' %网络准入% ' -- “网络准入”为列表名称
and tp_deletetransactionid = 0x
and tp_baseviewid is not null
and t.tp_id = a.tp_listid
from AllLists t,WebParts a
where t.tp_Title like N ' %网络准入% ' -- “网络准入”为列表名称
and tp_deletetransactionid = 0x
and tp_baseviewid is not null
and t.tp_id = a.tp_listid