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]
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 :
Post a Comment