getallocated_page_page_id of a table MS SQL Server

allocated_page_page_id.sql

WITH dataCTE
AS
(	
	SELECT allocated_page_page_id, next_page_page_id, previous_page_page_id
	FROM sys.dm_db_database_page_allocations(DB_ID(), OBJECT_ID('dbo.TEMP_POS_TERR'),1, NULL, 'DETAILED')
	WHERE is_allocated = 1
	AND page_type_desc = 'DATA_PAGE'
)
,pageCTE
AS
(
	SELECT allocated_page_page_id, next_page_page_id, 1 AS page_sequence
	FROM dataCTE
	WHERE previous_page_page_id IS NULL

	UNION ALL

	SELECT d.allocated_page_page_id, d.next_page_page_id, p.page_sequence +1 AS page_sequence
	FROM pageCTE AS p
	JOIN dataCTE AS D
	ON d.allocated_page_page_id = p.next_page_page_id
)
SELECT allocated_page_page_id, page_sequence
FROM pageCTE
ORDER BY page_sequence
option (maxrecursion 0);