How can I delete entire data from tables in SQL database

See more:

SQL-Server-2008R2

Hii friends i have some issue to delete the data in databse.i want empty database in in table ..i have to search in google but i didnt find correct answer as simply

...
...

advance thanks to you

What I have tried:

i tried in this way first i copy the (some) data base data and again paste it same data source with new name but in their data ..i want empty database how can i get



CREATE PROCEDURE sp_DeleteAllData AS EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' EXEC sp_MSForEachTable 'ALTER TABLE ? DISABLE TRIGGER ALL' EXEC sp_MSForEachTable 'DELETE FROM ?' EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL' EXEC sp_MSForEachTable 'ALTER TABLE ? ENABLE TRIGGER ALL' EXEC sp_MSFOREACHTABLE 'SELECT * FROM ?' GO - See more at: http://www.devx.com/dbzone/Article/40967#sthash.fv051CNG.dpuf


i have try this code but i didnt get where i put the my database name..plz help me