Tell me more ×
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.
up vote 1 down vote favorite

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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.