I'm a newbie with SharePoint so apologies if my terminology is a bit shaky. I've got a situation where the "Title" column associated with all documents in a Document Library (SharePoint 2013) needs updating:
There are ~93K documents in this library so updating them manually isn't an option.
Is it possible to locate and update this column value via SQL? I've been looking at the WSS_Content database but I can't seem to find any reference to columns in there. AllDocs has a column MetaInfo - would this contain the data in binary format?
If it's not possible to do it via SQL, what would be the easiest way to do the update? Can it be done using PowerShell?
Thanks...