SQLUSA

Microsoft SQL Server 2005 Best Practices

 

How to obtain the definition of all the functions?

 

Execute the following script in Query Editor to obtain the definition of scalar-valued, in-line and table-valued functions:

USE AdventureWorks;

SELECT Type, Definition
FROM sys.sql_modules m
JOIN sys.objects o
ON m.object_id = o.object_id
AND TYPE IN ('FN', 'IF', 'TF')
ORDER BY Type, Definition;


 

American Standard in SQL Server 2005 Training
 
 
SQLUSA.com Home Page