If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

How to remove all object from a db

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.