Click here to Skip to main content
14,669,117 members
Rate this:
Please Sign up or sign in to vote.
See more:
For Sharepoint 2010 content database, in which table and column is the list item attachment file saved
Posted

Rate this:
Please Sign up or sign in to vote.

Solution 1

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.
   
Rate this:
Please Sign up or sign in to vote.

Solution 4

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
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100