在 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 部件来提取表的扩展属性，然后允许我编辑它，然后在编辑完成后，web 部件更新 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屋！