Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does Teradata have a way to rename a primary key constraint, rather than dropping it and recreating it? I'm using SP_RENAME for SQL Server and ALTER TABLE...RENAME CONSTRAINT for Oracle, but I don't know a corresponding command for Teradata.

share|improve this question
If not, can the constraint be dropped and recreated (on Teradata v12) or does the entire table need to be dropped and recreated? – William Jun 26 '12 at 22:01
Constraint can be dropped and recreated while leaving the table alone. Haven't found anything on renaming yet. – lins314159 Jun 27 '12 at 0:41

no, renaming is not possible in Teradata but as already stated you can drop the constraint and recreate it

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.