openspecimen_demo
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
remove_cfg_prop
Parameters
Name
Type
Mode
moduleName
text
IN
propName
text
IN
Definition
begin delete s from os_cfg_settings s join os_cfg_props p on p.identifier = s.property_id join os_modules m on m.identifier = p.module_id where m.name= moduleName and p.name = propName; delete p from os_cfg_props p join os_modules m on m.identifier = p.module_id where m.name= moduleName and p.name = propName; end