[Column name] has_default_value [Description] 1 = Parameter has default value. SQL Server only maintains default values for CLR objects in this catalog view; therefore, this column has a value of 0 for Transact-SQL objects. To view the default value of a parameter in a Transact-SQL object, query the definition column of the sys.sql_modules catalog view, or use the OBJECT_DEFINITION system function. [Data type] 
bit
i n t
s y s n a m e
t i n y i n t
s m a l l i n t
b i t
s q l _ v a r i a n t