Hot answers tagged scripting
If you click on the 'Script' in the execute box that pops up from the delete button, it reveals that the script actually uses a DROP command: USE [DATABASE] GO /****** Object: Table [dbo].[TABLE] Script Date: 3/6/2014 9:29:39 AM ******/ DROP TABLE [dbo].[TABLE] GO
/****** Object: Database [DatabaseName] Script Date: 03/06/2014 10:32:06 AM ******/ DROP DATABASE [DatabaseName] GO However, you should probably just use the RESTORE DATABASE command and use the REPLACE option. REPLACE Specifies that SQL Server should create the specified database and its related files even if another database already exists with ...
Only top voted, non community-wiki answers of a minimum length are eligible