-- Created by Nicholas Littlefield CREATE or REPLACE FUNCTION add_prim_key () RETURNS void LANGUAGE plpgsql as $$ begin if NOT exists (select constraint_name from information_schema.table_constraints ...

To modify a primary key To modify a PRIMARY KEY constraint using Transact-SQL, you must first delete the existing PRIMARY KEY constraint and then re-create it with the new definition. For more ...