Hi Guys,
I have a database which contains tables with data, indexes, constraints, etc. Now i want to do two things.
(1). How can i remove all objects like tables,indexes,etc from my database so that i will get a clean database
(2). How can i remove all the objects except table. In this case i want to remove indexes,data,constraints,etc.

I need the script for both 1 & 2.

Immediate response is highly appreciated.

Best Regards,
Sudheer