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.