Rename primary key constraint in Teradata 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.
no, renaming is not possible in Teradata but as already stated you can drop the constraint and recreate it