Hi Sergy,
Thanks for the reply. I want to retrieve the constraint name that was created when I placed a default value on a field. I tried executing
sp_helpconstraint 'Tablename',nomsg
This gave me a list of all contraints. I tried executing the code that you gave but it does not return a result if the constraint type of the column is DEFAULT.
Did I missed on something?
Thanks...
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.