This script calculates table row count and size(MB), as well as the used space and free space.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.25 (8)

You rated this post out of 5. Change rating

2014-01-31 (first published: 2014-01-17)

2,152 reads

Blogs

Recently a customer asked how they could get index changes to be captured in...

giltwrights – n. the imaginary committee of elders that keeps a running log of...

Hey folks, fun personal post today. A few weeks ago, I got married! My...

Forums

Hello, so I was reading on partitioning a large table, Which i successfully did,...

Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...

USE [DBName] SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName] , SUM(sPTN.Rows) AS [RowCount]...