Nak delete stored procedure secara berjemaah dalam MSSQL Management Studio

Hello geng,

Sakit jiwa bila stored procedure dah berlambak2, nak delete berjemaah jenuh mencari. tak tau tang mana nak buat.

Last2 jumpa le cara dia. tiru ler dan ikut le arahan dibawah. aku dah terai. lega. beratus2 SP boleh delete (GUI guided). bukan main skrip aa.

Selamat menerai!

source: https://stackoverflow.com/questions/2610820/how-to-drop-all-stored-procedures-at-once-in-sql-server-database

1. In the Object Explorer pane, select the Stored Procedures folder.
2. Press F7 (or from the main menu, choose View > Object Explorer Details).
3. Select all procedures except the System Table.
4. Press Delete button and select OK.

You can delete Tables or Views in the same manner.