Search code examples
sqlsql-server-2008stored-proceduresparametersinformation-schema

Is there any Information to get default value of stored procedure Input parameters?

Is there any Information to get default value of stored procedure Input parameters is SQL Server side?

I can get information about stored procedure input parameters via INFORMATION_SCHEMA.PARAMETERS but this table does not give any info about Default Value of the parameters.

Solution

  • The value of each declared parameter must be supplied by the user when the procedure is called, unless a default for the parameter is defined or the value is set to equal another parameter.

    And all parameters are null-able as all data-types accept null.
    You can don't prompt a parameter by setting a default value to it.

    And you can use sys.parameters table for seeing default values.