内容数据库中的Sharepoint 2010列表项附件 [英] Sharepoint 2010 list item attachment in content database

问题描述

对于Sharepoint 2010内容数据库，其中表和列是保存的列表项附件文件

For Sharepoint 2010 content database, in which table and column is the list item attachment file saved

推荐答案

您不应该关注表和列。 Microsoft建议不要直接访问数据库，并且可以随时更改此模式。

You should not be concerned with the tables and columns. Microsoft recommends not accessing the databases directly and can change this schema at any time.

它在AllDocs表中，使用它：

it is in AllDocs Table,use this:

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT top 10 [Id]
      ,[SiteId]
      ,[DirName]
      ,[LeafName]
      ,[WebId]
      ,[ListId]
      ,[DoclibRowId]
      ,[Type]
      ,[SortBehavior]
      ,[Size]
      ,[ETagVersion]
      ,[EffectiveVersion]
      ,[InternalVersion]
      ,[BumpVersion]
      ,[UIVersion]
      ,[Dirty]
      ,[ListDataDirty]
      ,[CacheParseId]
      ,[DocFlags]
      ,[ThicketFlag]
      ,[CharSet]
      ,[ProgId]
      ,[TimeCreated]
      ,[TimeLastModified]
      ,[NextToLastTimeModified]
      ,[MetaInfoTimeLastModified]
      ,[TimeLastWritten]
      ,[DeleteTransactionId]
      ,[SetupPathVersion]
      ,[SetupPath]
      ,[SetupPathUser]
      ,[CheckoutUserId]
      ,[CheckoutDate]
      ,[CheckoutExpires]
      ,[VersionCreatedSinceSTCheckout]
      ,[LTCheckoutUserId]
      ,[VirusVendorID]
      ,[VirusStatus]
      ,[VirusInfo]
      ,[MetaInfo]
      ,[MetaInfoSize]
      ,[MetaInfoVersion]
      ,[UnVersionedMetaInfo]
      ,[UnVersionedMetaInfoSize]
      ,[UnVersionedMetaInfoVersion]
      ,[WelcomePageUrl]
      ,[WelcomePageParameters]
      ,[IsCurrentVersion]
      ,[Level]
      ,[CheckinComment]
      ,[AuditFlags]
      ,[InheritAuditFlags]
      ,[DraftOwnerId]
      ,[UIVersionString]
      ,[ParentId]
      ,[HasStream]
      ,[ScopeId]
      ,[BuildDependencySet]
      ,[ParentVersion]
      ,[ParentVersionString]
      ,[TransformerId]
      ,[ParentLeafName]
      ,[IsCheckoutToLocal]
      ,[CtoOffset]
      ,[Extension]
      ,[ExtensionForFile]
      ,[ItemChildCount]
      ,[FolderChildCount]
      ,[FileFormatMetaInfo]
      ,[FileFormatMetaInfoSize]
      ,[FFMConsistent]
      ,[ContentVersion]
      ,[ListSchemaVersion]
      ,[ClientId]
  FROM [WSS_Content].[dbo].[AllDocs]
  order by TimeCreated desc

这篇关于内容数据库中的Sharepoint 2010列表项附件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！