获取当前数据库中所有的用户定义函数名称

[sql]代码库

    SELECT udf.NAME
    FROM sys.all_objects AS udf
    WHERE (
            udf.type IN (
                'TF',
                'FN',
                'IF',
                'FS',
                'FT'
                )
            )
        AND CAST(CASE
                WHEN udf.is_ms_shipped = 1
                    THEN 1
                WHEN (
                        SELECT major_id
                        FROM sys.extended_properties
                        WHERE major_id = udf.object_id
                            AND minor_id = 0
                            AND class = 1
                            AND NAME = N'microsoft_database_tools_support'
                        ) IS NOT NULL
                    THEN 1
                ELSE 0
                END AS BIT) = 0