MS SQL Server - Function and Procedure Parameter Defaults

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Function and Procedure Parameter Defaults

semethyjr

2006-03-09, 8:23 pm

I am trying to find out where in the SQL Server 2005 system catalogs I can
get Function and Procedure parameter defaults. According to the
documentation, defaults for CLR Functions are store in sys.parameters. I
know I can parse the information out from sys.sql_modules, the defintion
column. I want to know if there is a system table that will store this
information.

CREATE FUNCTION [dbo].[somefunc] (@someparm INTEGER = 1001)
RETURNS.......

Sponsored Links