Skip to content

asp.net,c#.net, MVC, WPF, WCF, JavaScript, JQuery, SQL Server, Interview Q&A

Search for:

Tutorials
- C#
  - Object Oriented Programming
- ASP.NET
- ASP.NET MVC
- SQL SERVER
- WCF
- WPF
- HTML
- JavaScript
- Bootstrap
Interview Q&A
Tips & Tricks
Downloads
- SQL Downloads

053. Drop a Table from all Databases – SQL Server Script

November 11, 2020 Dhruv Sheth Performance Improvement in SQL, SQL Downloads, SQL SERVER, Sql Server Scripts

--Use sp_MSforeachdb, and execute a command in all databases:
 
exec sp_MSforeachdb
'use [?]
drop table table_name'

Sql Server Sql server helping Script

Post navigation

Previous Post:052. Check Newly Allocated Pages to the Table – SQL Server Script

Next Post:054. Rename all Tables of a Database – SQL Server Script

Email Subscription

Recent Posts

Different ways to concatenate strings in c# | Top 6 Ways to Concatenate String
Label Control in WPF Tutorials step by step-2
Hello World – WPF Tutorials Step by Step – 1
Deep dive with nullable value types in c# | Nullable in c#
133. SQL Server Script to find Installation Date, time and Authentication Mode
132. SQL Server Script to find the status of Trace is running or not
131. SQL Server Script to change the Recovery Model of a Database
130. SQL Server 2012 Introduced dm_db_log_space_usage to find a Log size
129. SQL Server Script to Enable and Disable XP_CMDSHELL Configuration
128. SQL Server Script to find uncontained objects of a Database

Archives

Tags

Android (1) Android Videos (1) ASP.NET (35) asp.net Interview Questions (6) ASP.NET MVC (7) Bootstrap (5) C# (63) C# Interview Questions (43) Downloads (3) GitHub (1) Google Tools (1) HTML (4) Interview Q&A (112) JavaScript (61) JavaScript Interview Questions (52) JQuery (6) LINQ To SQL (1) Mobile Operating System (0) News (2) Object Oriented Programming (3) Operating System (0) Performance Improvement in SQL (116) Programming Videos (0) SQL Downloads (134) SQL Interview Questions (65) SQL SERVER (190) Sql Server Scripts (135) SVN (1) Tips & Tricks (1) Tutorials (154) Uncategorized (1) Video Tutorials (0) WCF (3) WCF Interview Questions (5) Web API (1) Web API Interview Questions (1) WPF (9) Youtube API (1)

WordPress Theme: Tortuga by ThemeZee.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settings ACCEPT

Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities...

Necessary

Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

SAVE & ACCEPT

Thank you for visiting. You can now buy me a coffee!

Help US

Please disable your adblocker or whitelist this site!