If I have visual sql database project, I want to drop all the objects in the database and create them again without dropping the actual DB. Is there a way to do that, if so how do I select this in the publish settings?
Asked
Active
Viewed 1,159 times
1 Answers
0
Use generate script (SQL Server), it will generate a query for dropping and re creating the object on your database. here is another post,try to read it. Hope this helps. Generate script in SQL Server Management Studio
Ikyong
- 123
- 7