Breaking News: Grepper is joining You.com. Read the official announcement!

how to drop all tables in sql

Add Answer

Plain Panther answered on July 6, 2020 Popularity 10/10 Helpfulness 4/10

answer how to drop all tables in sql

related drop all tables

related sql drop all tables

related delete all tables from database

related drop all data from tables

related sql drop all tables

related SQL Query to delete all the tables in a database

related sql delete all the database tables

related how to delete all tables in a database

how to drop all tables in sql

Comment

-1

USE Databasename

SELECT  'DROP TABLE [' + name + '];'
FROM    sys.tables

Popularity 10/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: drop sql

Link to this answer
Share Copy Link

Contributed on Aug 22 2021

Plain Panther

0 Answers Avg Quality 2/10

Closely Related Answers

drop all tables

Comment

DROP DATABASE db_name;
CREATE DATABASE db_name;

Popularity 10/10 Helpfulness 6/10 Language sql

Source: stackoverflow.com

Tags: drop

Link to this answer
Share Copy Link

Contributed on Oct 17 2022

Murat Cakmak

0 Answers Avg Quality 2/10

sql drop all tables

Comment

-- To drop all tables in a database, do this:

DROP SCHEMA public CASCADE;
CREATE SCHEMA public;

-- If all of your tables are in a single schema, this approach could work
-- (assumes that the name of your schema is public)

Popularity 9/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Aug 03 2023

Dark Dotterel

0 Answers Avg Quality 2/10

delete all tables from database

Comment

-- Drop all tables from a database
USE your_database_name; -- Replace "your_database_name" with the actual name of the database you want to delete tables from

DECLARE @sql NVARCHAR(MAX) = N'';

SELECT @sql += N'DROP TABLE ' + QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) + ';
'
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE';

EXEC(@sql);

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

drop all data from tables

Comment

-1

DELETE FROM my_table;			-- all rows, needs a COMMIT to validate
TRUNCATE TABLE my_table;			-- all rows, quicker, no possible roolback

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: drop

Link to this answer
Share Copy Link

Contributed on May 08 2021

VasteMonde

0 Answers Avg Quality 2/10

sql drop all tables

Comment

DECLARE @sql NVARCHAR(max)=''

SELECT @sql += ' Drop table ' + QUOTENAME(TABLE_SCHEMA) + '.'+ QUOTENAME(TABLE_NAME) + '; '
FROM   INFORMATION_SCHEMA.TABLES
WHERE  TABLE_TYPE = 'BASE TABLE'

Exec Sp_executesql @sql

Popularity 10/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Oct 18 2021

Successful Salamander

0 Answers Avg Quality 2/10

sql drop all tables

Comment

-- Generate drop table commands for each table in the database
SELECT 'DROP TABLE ' || table_name || ';' AS drop_table_command
FROM information_schema.tables
WHERE table_schema = 'public' -- Specify the schema name if needed
  AND table_type = 'BASE TABLE';

-- Execute the generated drop table commands to drop all tables
DO $$ DECLARE
    drop_table_command text;
BEGIN
    FOR drop_table_command IN (
        SELECT 'DROP TABLE ' || table_name || ';' AS drop_table_command
        FROM information_schema.tables
        WHERE table_schema = 'public' -- Specify the schema name if needed
          AND table_type = 'BASE TABLE'
    )
    LOOP
        EXECUTE drop_table_command;
    END LOOP;
END $$;

Popularity 8/10 Helpfulness 2/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

SQL Query to delete all the tables in a database

Comment

-1

BY LOVE

EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
DECLARE @sql NVARCHAR(max)=''

SELECT @sql += ' Drop table ' + QUOTENAME(TABLE_SCHEMA) + '.'+ QUOTENAME(TABLE_NAME) + '; '
FROM   INFORMATION_SCHEMA.TABLES
WHERE  TABLE_TYPE = 'BASE TABLE'
Exec Sp_executesql @sql

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: database databas

Link to this answer
Share Copy Link

Contributed on Jul 06 2020

Nice Nightingale

0 Answers Avg Quality 2/10

sql delete all the database tables

Comment

DO $$ 
DECLARE 
    v_table_name text; 
BEGIN 
    FOR v_table_name IN (SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_type = 'BASE TABLE') 
    LOOP 
        EXECUTE 'DROP TABLE IF EXISTS ' || v_table_name || ' CASCADE'; 
    END LOOP; 
END $$;

Popularity 5/10 Helpfulness 2/10 Language sql

Source: chat.openai.com

Tags: sql sql-delete

Link to this answer
Share Copy Link

Contributed on Mar 04 2024

Fine Fox

0 Answers Avg Quality 2/10

how to delete all tables in a database

Comment

-- Assuming the user wants to delete all tables in a MySQL database
-- Connect to your database first

-- Get a list of all tables in the database
SELECT GROUP_CONCAT(table_name) INTO @tablesToDelete
FROM information_schema.tables
WHERE table_schema = 'your_database_name';

-- Construct the SQL query to delete all tables
SET @query = CONCAT('DROP TABLE IF EXISTS ', @tablesToDelete);

-- Execute the SQL query to delete all tables
PREPARE stmt FROM @query;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

Popularity 8/10 Helpfulness 2/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 11 2023

YOU.com

0 Answers Avg Quality 2/10

how to drop all tables in sql

Contents

More Related Answers

how to drop all tables in sql

Closely Related Answers

drop all tables

sql drop all tables

delete all tables from database

drop all data from tables

sql drop all tables

sql drop all tables

SQL Query to delete all the tables in a database

sql delete all the database tables

how to delete all tables in a database

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.