openspecimen_demo
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
rename_pv_attribute
Parameters
Name
Type
Mode
oldAttrName
text
IN
newAttrName
text
IN
newCaption
text
IN
newDef
text
IN
version
text
IN
Definition
begin insert into catissue_cde (public_id, long_name, definition, version, last_updated) values (newAttrName, newCaption, newDef, version, now()); update catissue_permissible_value set public_id = newAttrName where public_id = oldAttrName; delete from catissue_cde where public_id = oldAttrName; end