Tuesday, August 9, 2016

Sitecore Database Internal -Items, VersionedFields and UnVersionedFields

These tables pretty much make sitecore CMS. Items and values stored in fields. Everything is just an ITEM.


SELECT [Id]
      ,[ItemId]
      ,[Language]
      ,[FieldId]
      ,[Value]
      ,[Created]
      ,[Updated]
      ,[DAC_Index]
  FROM [Sitecore_master].[dbo].[UnversionedFields]

SELECT [Id]
      ,[ItemId]
      ,[Language]
      ,[Version]
      ,[FieldId]
      ,[Value]
      ,[Created]
      ,[Updated]
      ,[DAC_Index]
  FROM [Sitecore_master].[dbo].[VersionedFields]

SELECT [ID]
      ,[Name]
      ,[TemplateID]
      ,[MasterID]
      ,[ParentID]
      ,[Created]
      ,[Updated]
      ,[DAC_Index]
  FROM [Sitecore_master].[dbo].[Items]

No comments :