Edit SQL Extended Properties in SharePoint 2010

问题:

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

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.

回答1:

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.