在SharePoint 2010中编辑SQL扩展属性 [英] Edit SQL Extended Properties in SharePoint 2010

问题描述

如何在SharePoint 2010中编辑表的扩展属性?

How can I edit extended properties of a table in SharePoint 2010?

到目前为止，我认为还没有开箱即用"的功能可以做到这一点.因此，我假设这意味着我将必须制作一个自定义Web部件，以提取表的扩展属性，然后允许我对其进行编辑，然后在编辑完成后，该WebPart将在SQL中更新扩展属性.

So far, I'm thinking there's nothing 'out-the-box' that does this. So, I'm assuming this means that I will have to make a custom web-part that extracts the extended properties of a table, then allows me to edit that, and then after editing is complete, the webpart updates the extended properties in SQL.

我正在尝试找出是否有一种方法可以不使用代码(即装即用的功能)，或者这是唯一的方法.

I'm trying to figure out if there's a way to do this without using code (out the box features or something) OR if this is the ONLY way to do it.

推荐答案

一旦这些属性位于单独的表中，请基于该列表创建外部内容类型.然后，您可以基于该内容类型创建一个外部表，并编辑存储在该SQL Server表中的数据.

Once these properties are in a separate table, create an external content type based on that list. You can then create an external table based on that content type and edit the data stored in that SQL Server table.

这篇关于在SharePoint 2010中编辑SQL扩展属性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！