Thursday, 22 November 2012

how to check how much function in database


USE test
SELECT name AS function_name
,SCHEMA_NAME(schema_id) AS schema_name
,type_desc
FROM sys.objects
WHERE type_desc LIKE '%FUNCTION%';

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home