-- 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)

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

-- 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);

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

-- 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;

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

-- 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 $$;

{"tags":[{"tag":"p","content":"1.Right click the database\n "},{"tag":"p","content":"2.Go to \"Tasks\"\n "},{"tag":"p","content":"3.Click \"Generate Scripts\"\n "},{"tag":"p","content":"4.In the \"Choose Objects\" section, select \"Script entire database and all database objects\"\n "},{"tag":"p","content":"5.In the \"Set Scripting Options\" section, click the \"Advanced\" button\n "},{"tag":"p","content":"6.On \"Script DROP and CREATE\" switch \"Script CREATE\" to \"Script DROP\" and press OK\n "},{"tag":"p","content":"7.Then, either save to file, clipboard, or new query window.\n "},{"tag":"p","content":"8.Run script. "}]}