SQL Tip: Query to get Table Statistics

SQL Query to get the Table(s) Statistics like RowCount, CreatedDate, Page Size etc., on a given Database:

SELECT s.Name SchemaName
, o.Name TableName
, coalesce(i.Name, 'HEAP') IndexName
, p.used_page_count * 8 UsedPageCountInKB
, p.reserved_page_count * 8 ReservedPageCountInKB
, p.row_count RowsCount
, t.create_date CreatedDate
, t.modify_date ModifiedDate
, t.max_column_id_used Columns
FROM sys.dm_db_partition_stats p
INNER JOIN sys.objects as o
ON o.object_id = p.object_id
INNER JOIN sys.schemas as s
ON s.schema_id = o.schema_id
INNER JOIN
sys.tables t ON t.object_id = o.object_id
LEFT OUTER JOIN sys.indexes as i
on i.object_id = p.object_id and i.index_id = p.index_id
WHERE o.type_desc = 'USER_TABLE'
and o.is_ms_shipped = 0
ORDER BY
p.row_count DESC