How to view/edit extended properties of SQL Table in SharePoint 2010

Question

Possible Duplicate:
Edit SQL Extended Properties in SharePoint 2010

Hi everyone,

I know how to view/edit table data from an external SQL (non SharePoint) database from my SharePoint 2010 web front end.

However, I also want to view/edit the extended properties (metadata) as well.

How can I do this?

Thanks!

Answer 1

You don't make clear if you are wanting to access a SharePoint Database (not supported as NLV say) or a.n.other database via SharePoint.

I am assuming the latter.

There are lots of table viewer/editor web parts but I don't know of any that let you work with metadata so you're probably going to have to develop your own - this guide and this one are for a viewer but should give you a head start.