• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2416
  • Last Modified:

Renaming a Constraint

Is is possible to rename a constraint once it's created (In Query Analyzer)....besides Dropping it and Recreating it.
0
phunchak
Asked:
phunchak
  • 2
1 Solution
 
patriktCommented:
NO.

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.

Patrik
0
 
phunchakAuthor Commented:
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.
0
 
patriktCommented:
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.

0
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now