Use sp_help to get UDF parameters. 1

[Durkin]

Hi. I'm trying to query the database to return the parameters for a user defined function in the same way that you can for a stored proc using sp_help but sp_help seems not to work for functions. Is there any other way?
Thanks,

Durkin

 

[hmckillop]

You can use the system tables
select * from syscolumns sysc
inner join sysobjects syso on syso.id = sysc.id
where syso.name = 'ufn_MyFunction'

 

[Durkin]

Perfect. Thank you.

Durkin