SQL Server List Partitioned Tables with Row Count and Page Size

SQL Server script to list database tables that are partitioned with the partitions schema, partition function, row count, page size, and partition range.