@GayathriG1080 we don't recommend updating the DB directly.  If you wish to achieve this, each proposition has an active flag, this can be changed as appropriate.  You should not need to do this directly in production, instead you should make use of change management capability to do this (Ops Manager or if prior to 8.5 Revision management).  

In the absence of this you can deploy a change directly to production to switch off but this is likely more cumbersome than using our change management capability.