Sql Qurey to Select Multiple Tabels and Procedure

select * from sys.tables Where name like 'tblKool%'
select * from sys.procedures Where name like 'spKool%' order by name
BEGIN
FOR r in (SELECT object_name FROM user_objects WHERE object_type = 'PROCEDURE' )
LOOP
EXECUTE IMMEDIATE 'DROP PROCEDURE 'r.object_name;
END LOOP
END