How to generate script to drop tables?

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
Thenrich
Posts: 105
Joined: Sun 21 Dec 2014 19:47

How to generate script to drop tables?

Post by Thenrich » Sat 04 Nov 2017 02:09

How to generate script to drop tables? I don't see an option for this in Generate Scripts..

alexa

Re: How to generate script to drop tables?

Post by alexa » Mon 06 Nov 2017 15:38

In case you were referring to dbForge Studio for SQL Server, you have to perform the following:
1. Expand a database in Database Explorer.
2. Expand the 'Tables' node.
3. Right-click a table(or multi-selection) and select 'Generate Script As -> DROP' from the popup menu.

Post Reply