SELECT t.NAME [table] ,p.rows ,p.partition_number ,v.boundary_id ,v.value FROM sys.tables t INNER JOIN sys.partitions p ON p.object_id = t.object_id INNER JOIN sys.partition_range_values v ON v.boundary_id = p.partition_number WHERE is_ms_shipped = 0 ORDER BY [table]
No comments:
Post a Comment