כניסה
 
עמוד הביתספריהלמדהורדותאיתר וטיפל בבעיותקהילהפורומים
משאבים למומחי מחשוב >
> 
> 
Query for a third party special column in content db

תשובה Query for a third party special column in content db

  • יום שני 28 מאי 2012 07:40
     
     
    היכנס כדי להצביע
    0

    Hi,<o:p></o:p>

    I bought a third party cascading filter solution to my WSS3 environment and implement it in many sites/lists.

    Now I migrate to the new SharePoint 2010 Server and I want to query the content DB's in order to find and delete those entire. Do you know
    which table holds the columns that are in each list?<o:p></o:p>

    Thank a lot in advance<o:p></o:p>


     

כל התגובות

  • יום רביעי 30 מאי 2012 06:51
     
     
    היכנס כדי להצביע
    0

    First of all, a warning: You are not allowed to query or modify the content databases of SharePoint directly or you forfait your chances to Microsoft support.

    Now that being said, what you are looking for is tp_Fields column in the dbo.AllLists table of the content database. The tp_Fields holds all the information about each list column in XML format.

    I do not recommend making modifications to this table in any way.

    If you need to change the fields of some lists, consider using the Powershell approach to interrqct with the SharePoint object model, which is a supported method.

    Dirk Van den Berghe


     
  • יום רביעי 30 מאי 2012 14:41
     
     תשובה
    היכנס כדי להצביע
    0

    Thanks Dirk,

    I don't need to modify nothing just to query (SELECT) for a specific column type that's a third party one. Do you have any example code for that?

    • סומן כתשובה על-ידי arevach יום ראשון 03 יוני 2012 15:30
    •