>>Hi,
>>
>>I need to change a name of the default constraint in a table. When I go to this table via SSMS, select the table, open Constraint, right-mouse click on the one I want to change, select Rename. Change the name, press Enter. But the old name reappears. What can I do to change it? TIA.
>
>Try dropping the constraint and re-create.
>
>Found also this
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=462046>not sure if related to your problem
>
>See also
http://www.sql-questions.com/microsoft/SQL-Server/32159734/default-constraint-names.aspx for sp_rename syntax.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham