How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)?'
'Question: How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)?
Answer: I just received this question the other day during Comprehensive Database Performance Health Check. My initial answer was that you can easily script it out like following:
1
2
3
4
|
DROP TABLE [dbo].[InMemory_Columnstore_People]
GO
DROP TABLE [dbo].[InMemory_People]
GO
|
However, the DBA asked me the question once again saying, he is quite familiar with the T-SQL script but he would love to know if there is a shortcut to do that via SSMS. Essentially he would love to drop multiple tables via keyboard in SQL Server Management Studio.
Fortunately, it is totally possible to do so. Here are the steps...'...
Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt