DATABASEPROPERTYEX – is for database properties
INDEXPROPERTY – for index properties

– Helps in finding fill factor, clustered index column, identity column, statistics updated or not etc.,

[cc lang=”SQL”]
SELECT sysobjects.name,
sysindexes.name,
INDEXPROPERTY(OBJECT_ID(sysobjects.name),sysindexes.name,’IndexFillFactor’)
FROM sysobjects INNER JOIN
sysindexes ON sysobjects.id = sysindexes.id
WHERE xtype = ‘U’
[/cc]