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.
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.