How to drop all tables from a database with one SQL query

0 votes
drop all tables without typing name. Is it possible with one query?
Jun 7, 2022 in Others by polo
 • 1,480 points • 467 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

The simplest way is to drop the whole database and create it once again:

drop database db_name
create database db_name

That's all.

answered Jun 7, 2022 by nisha
 • 2,210 points
edited Mar 5

Related Questions In Others

0 votes
0 answers

How to drop all tables from a database with one SQL query?

What if we don't want to type ...READ MORE

May 28, 2022 in Others by Sohail
 • 3,040 points • 669 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
 • 86,360 points • 1,539 views
0 votes
1 answer

How to build a custom column formula in Power query that will retrieve Image and load it to Excel to display that image from the specified column

Make sure ignore privacy is selected in ...READ MORE

answered Feb 5, 2023 in Others by narikkadan
 • 86,360 points • 1,512 views
0 votes
1 answer

How to read a dataframe from an excel sheet containing multiple tables?

Here is one option with scikit-image  import numpy as ...READ MORE

answered Apr 4, 2023 in Others by Kithuzzz
 • 38,000 points • 3,980 views
0 votes
0 answers

Copying values from multiple excel files to a single one with python

I want to replicate the values from ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
 • 38,000 points • 1,188 views
0 votes
1 answer

How to search a file with a particular extension and a particulat string in its name?

You can easily find the file using ...READ MORE

answered Mar 8, 2019 in Others by Nabarupa
 • 1,249 views
0 votes
1 answer

Calculate Time Intersection to Correlate Sequences of Independent Events

I think this solution requires a CROSS JOIN implementation. ...READ MORE

answered Oct 26, 2018 in Power BI by Upasana
 • 8,620 points • 1,052 views
0 votes
1 answer

How do I UPDATE from a SELECT in SQL Server?

MERGE INTO YourTable T USING ...READ MORE

answered Feb 3, 2022 in Database by Vaani
 • 7,070 points • 1,095 views
0 votes
0 answers

How do I UPDATE from a SELECT in SQL Server?

INSERT INTO Table (col1, col2, col3) SELECT col1, ...READ MORE

Feb 4, 2022 in Database by Vaani
 • 7,070 points • 729 views
0 votes
1 answer

What is a stored procedure?

A stored procedure is a set of ...READ MORE

answered Feb 4, 2022 in Database by Neha
 • 9,020 points • 1,348 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.