Be Alpha
Monday, September 2, 2019
SQL Server list partitioned tables
SELECT partition_number,rows,object_name(object_id)
FROM sys.partitions s
WHERE EXISTS(SELECT NULL
FROM sys.partitions s2
WHERE s.object_id = s2.object_id
AND partition_number > 1
AND s.index_id = s2.index_id);
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment