Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

1 Answer

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

share|improve this answer
add comment

Your Answer

 
discard

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.