INSERT INTO #TEMPFRAG
SELECT OBJECT_NAME(F.OBJECT_ID) OBJ,I.NAME IND,
F.AVG_FRAGMENTATION_IN_PERCENT,
F.PAGE_COUNT,TABLE_SCHEMA
FROM SYS.DM_DB_INDEX_PHYSICAL_STATS (DB_ID(),NULL,NULL,NULL,NULL) F
JOIN SYS.INDEXES I
ON(F.OBJECT_ID=I.OBJECT_ID)AND I.INDEX_ID=F.INDEX_ID
JOIN INFORMATION_SCHEMA.TABLES S
ON (S.TABLE_NAME=OBJECT_NAME(F.OBJECT_ID))
--WHERE INDEX_ID<> 0
AND F.DATABASE_ID=DB_ID()
AND OBJECTPROPERTY(I.OBJECT_ID,''ISSYSTEMTABLE'')=0'

INSERT INTO #TEMPFRAG
SELECT	OBJECT_NAME(F.OBJECT_ID)
,		I.NAME IND
,		F.AVG_FRAGMENTATION_IN_PERCENT
,		F.PAGE_COUNT
,                     s.name -- NOTE CHANGED FROM TABLE_SCHEMA
--,		i.allow_page_locks -- I use this to better handle allow_page_locks true / false
FROM	SYS.DM_DB_INDEX_PHYSICAL_STATS ('+cast(@DB_ID as varchar)+',NULL,NULL,NULL,NULL) F
JOIN	SYS.INDEXES I ON(F.OBJECT_ID=I.OBJECT_ID) AND I.INDEX_ID=F.INDEX_ID  and i.is_disabled = 0 -- Note I'm skipping disabled indexes
join	sys.tables t on f.object_id = t.object_id -- NOTE NEW LINE TO REPLACE USE OF INFORMATION_SCHEMA
join	sys.schemas s on s.schema_id = t.schema_id -- NOTE NEW LINE TO COMPLETE JOIN
--WHERE INDEX_ID<> 0
	AND F.DATABASE_ID=DB_ID()
	AND	OBJECTPROPERTY(I.OBJECT_ID,''ISSYSTEMTABLE'')=0

declare @DB_ID int
set @DB_ID= DB_ID('Your DB Name Here')