惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

P
Privacy International News Feed
I
Intezer
T
Tenable Blog
S
Schneier on Security
Project Zero
Project Zero
G
GRAHAM CLULEY
酷 壳 – CoolShell
酷 壳 – CoolShell
小众软件
小众软件
Know Your Adversary
Know Your Adversary
博客园 - 司徒正美
The Cloudflare Blog
Recent Commits to openclaw:main
Recent Commits to openclaw:main
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
N
News and Events Feed by Topic
博客园 - 叶小钗
宝玉的分享
宝玉的分享
L
LINUX DO - 热门话题
aimingoo的专栏
aimingoo的专栏
S
Secure Thoughts
Forbes - Security
Forbes - Security
T
The Exploit Database - CXSecurity.com
D
Darknet – Hacking Tools, Hacker News & Cyber Security
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
博客园 - 【当耐特】
罗磊的独立博客
IT之家
IT之家
H
Hacker News: Front Page
I
InfoQ
云风的 BLOG
云风的 BLOG
S
Security Affairs
M
MIT News - Artificial intelligence
GbyAI
GbyAI
Jina AI
Jina AI
Help Net Security
Help Net Security
Engineering at Meta
Engineering at Meta
大猫的无限游戏
大猫的无限游戏
Webroot Blog
Webroot Blog
L
Lohrmann on Cybersecurity
A
About on SuperTechFans
Attack and Defense Labs
Attack and Defense Labs
The Register - Security
The Register - Security
V
V2EX
G
Google Developers Blog
D
DataBreaches.Net
Apple Machine Learning Research
Apple Machine Learning Research
C
Cybersecurity and Infrastructure Security Agency CISA
J
Java Code Geeks
W
WeLiveSecurity
Cloudbric
Cloudbric
T
Tor Project blog

博客园 - Peter Wang

SharePoint 备忘录 Different users – Calendar Audience Targeting Guide SharePoint 2010 Audit log report SharePoint workspace 2010同步功能 SharePoint 2010 bug sharepoint 引用不起作用 整合Bing Maps silverlight performance tip DotNet软件测试实战技术 VSTS 架构版share 敏捷开发中的项目管理利器-Mingle Castle揭密2----IOC(1) Castle揭密2----IOC(3) Castle揭密2----IOC(2) Castle揭密1--前言 概念回顾--MDA 概念回顾---中间件(IDC) 实现Web Service依赖倒置 SQL Server 索引结构及其使用(四) SQL Server 索引结构及其使用(三)
查找ContentType的依赖项
Peter Wang · 2010-12-09 · via 博客园 - Peter Wang

SharePoint中ConentType有时候删除不掉,一定是被哪些内容依赖。有些时候很抓狂,自认为删掉了所有的依赖项,但还是不能删除。只好直接去db查找content type的依赖项.找到内容库的ContentTypeUsage,发现ContentTypeId是varbinary内容。使用fn_varbintohexstr函数进行转换,sql语句如下。

SELECT  SiteId, sys.fn_varbintohexstr(ContentTypeId) AS ID, WebId, ListId, IsFieldId, Class
FROM    ContentTypeUsage
WHERE   (sys.fn_varbintohexstr(ContentTypeId) LIKE '0x01004d5a79bafa4a4576b79c56ff3d0d662d%')

找到对应的依赖项后,解除依赖或删除对应的依赖项,然后再删除此content type。