CREATE VIEW Metadata.Hobts
AS
SELECT o.OBJECT_ID AS ObjectId,
p.hobt_id AS HobtId,
s.name AS SchemaName,
o.name AS TableName,
p.ROWS,
rv.Value,
rv.boundary_id AS BoundaryId,
i.data_space_id AS DataSpaceId,
pf.name AS FunctionName,
ps.name AS SchemeName
FROM sys.partitions p (NOLOCK)
INNER JOIN sys.objects o (NOLOCK) ON o.OBJECT_ID = p.OBJECT_ID
INNER JOIN sys.schemas s (NOLOCK) ON s.SCHEMA_ID = o.SCHEMA_ID
LEFT OUTER JOIN sys.indexes i (NOLOCK) ON i.OBJECT_ID = p.OBJECT_ID
AND i.index_id = p.index_id
LEFT OUTER JOIN sys.partition_schemes ps (NOLOCK) ON ps.data_space_id = i.data_space_id
LEFT OUTER JOIN sys.partition_functions pf (NOLOCK) ON pf.function_id = ps.function_id
LEFT OUTER JOIN sys.partition_range_values rv (NOLOCK) ON rv.function_id = pf.function_id
AND p.partition_number = rv.boundary_id
WHERE o.is_ms_shipped = 0