Complete Programming Stuff
.NET and SQL codes
Labels
SQL
(14)
Common static functions
(4)
ASP.NET
(1)
Other
(1)
Monday, January 28, 2013
SQL Query to display all User Defined Functions
SELECT
name
AS
function_name
,
SCHEMA_NAME
(
schema_id
)
AS
schema_name
,
type_desc
FROM
sys
.
objects
WHERE
type_desc
LIKE
'%FUNCTION%'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment