Renaming a Constraint

Posted on 2004-08-17
Medium Priority
Last Modified: 2012-08-13
Is is possible to rename a constraint once it's created (In Query Analyzer)....besides Dropping it and Recreating it.
Question by:phunchak
  • 2
LVL 12

Accepted Solution

patrikt earned 150 total points
ID: 11824614

Constraints, Indexes atc. can be only droped and recreated.

If you want to seve time during recreation use WITH NOCHECK. It'll skip existing records checking.


Author Comment

ID: 11824687
That's what I thought...
Although in Enterprise manager you can rename a PK or FK constraint or an index through the manage relationships button.   Although the one I want to change is a Default constraint which doesn't show up on the list.
LVL 12

Expert Comment

ID: 11824740
Be avare that if you rename something in EM it can result in drop/create and sometimes to create/copy/drop operation. This can have big impact on your server performance if done in "bad" moment.


Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question