Hi,
Does anyone know how to filter tables in Object Explorer that have 0 rows? For example, out of 100 tables 40 of them are empty and I do not wish to see them in Object Explorer.
Thanks
Hi,
Does anyone know how to filter tables in Object Explorer that have 0 rows? For example, out of 100 tables 40 of them are empty and I do not wish to see them in Object Explorer.
Thanks
Hello, Bane!
You can use the code in ObjExp filter to hide empty tables:
ISNULL((SELECT SUM(spart.rows)
FROM sys.partitions spart
WHERE spart.object_id = obj.object_id AND
spart.index_id <> 0
Maria.