Post reply

Default values for stored procedure params

  • May 30, 2003 at 7:56 am

    #80169

    Hello everyone,

    I try to get default values for stored procedure parameters. With tables it is easy. I just look for cdefault from syscolumns and then for text in syscomments by cdefault and colid. With stored procedures cdefault is always 0 in syscolumns even if the default value exists.

    Do you konw any way to retrive default value for proc or function parameter without parsing entire body of the object?

    Marek Adamczuk

  • May 30, 2003 at 9:21 am

    #459203

    I don't think the default value for a sp parameter is in any column. But I guess you can search in the text column of the syscomments tables, for the stored procedures you are looking for, but it is not the best solution.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply