SELECT OBJECT_NAME(m.object_id) AS [Function Name] ,is_inlineable ,inline_type FROM sys.sql_modules AS m WITH (NOLOCK) LEFT OUTER JOIN sys.dm_exec_function_stats AS efs WITH (NOLOCK) ON m.object_id = efs.object_id WHERE efs.type_desc = N'SQL_SCALAR_FUNCTION' OPTION (RECOMPILE);