How to delete database sql management studio?
Extremely noobish question, but I really am a bleeding beginner when it comes to databases and SQL Server in particular.
I created a database which I populated it with some test data, and now it's time to make room for the real data. Except, I cannot find an easy way to delete my old test data from the tables. And to my astonishment, google won't help me.
I found a multitude of posts about how to delete tables, but I still need those. It's only the data I don't need.
Drawing on my (very limited) experience with databases, though, deleting tables and recreating them seems to be a common method, except that I didn't find anything on how to recreate the table in SQL Server Managment Studio. Apart from the obvious "by hand" method, at least.
As it stands, I'm going through my tables in the right order deleting the rows manually, but that's hardly an economic way to do it in the future. So how can I get rid of all the data in the table (or every table, for that matter) while still having the table structure afterwards?