Newsfeed

Articles

Videos

Post

Blog

Asked Question
Followers: 204
delete all tables from the database that start with "HR"

You can delete all tables from the database that start with "HR" using the following SQL script:


 

sql

Copy code

DECLARE @TableName NVARCHAR(128) DECLARE @Sql NVARCHAR(MAX) -- Cursor to iterate over all tables starting with 'HR' DECLARE table_cursor CURSOR FOR SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME LIKE 'HR%' OPEN table_cursor FETCH NEXT FROM table_cursor INTO @TableName WHILE @@FETCH_STATUS = 0 BEGIN -- Build the DROP TABLE command SET @Sql = 'DROP TABLE [' + @TableName + ']' EXEC sp_executesql @Sql FETCH NEXT FROM table_cursor INTO @TableName END CLOSE table_cursor DEALLOCATE table_cursor

Explanation:

  • Cursor: Iterates over all table names in the database that start with "HR".
  • INFORMATION_SCHEMA.TABLES: This system view provides information about all tables in the database.
  • DROP TABLE: Deletes each table found by the cursor.

Running this script will delete all tables starting with "HR" from your database.

Share This with your friend by choosing any social account


Upcoming Articles
You may also read following recent Post
Item Image

table not used or accesses in last 60 da...

By Junaid A
192

See Details
Item Image

delete all tables from the database that...

By Junaid A
127

See Details
Item Image

restart sql services using command

By Junaid A
110

See Details
Item Image

The Programming Language Powering MS SQ...

By abrar arshad
323

See Details
Item Image

Search value in database and return tabl...

By Junaid A
280

See Details
Item Image

how to find changes in database

By Junaid A
366

See Details
Item Image

How to caculate Date of Age in ms sql se...

By Junaid A
304

See Details
Item Image

How to download SQL Server 2019

By Junaid A
298

See Details
Item Image

Error handline in sql script

By Junaid A
387

See Details
Item Image

how to check tables and number of rows i...

By Junaid A
407

See Details
Item Image

The backend version is not supported to ...

By Junaid A
804

See Details
Item Image

check which sp has more lines

By Junaid A
407

See Details
Item Image

How to check which database table has mo...

By Junaid A
410

See Details
Item Image

how to check modification in ms sql data...

By Junaid A
317

See Details
Item Image

How To Solve MS SQL SERVER Saving Change...

By Ubaid ur Rehman
1590

See Details
Item Image

procedure to take most viewed products?

By Zaif Ullah
863

See Details
Item Image

procedure to take recent viewed products...

By Zaif Ullah
784

See Details
Item Image

procedure to take related products?

By Zaif Ullah
818

See Details
Item Image

procedure to take product by catagories?

By Zaif Ullah
718

See Details
Item Image

What is pivot Operator ?? Why use Pivot ...

By Rizwan Saqib
868

See Details
Item Image

How Delete all Tables of database Record...

By Rizwan Saqib
963

See Details
Item Image

What is Aliases in SQL?

By Rizwan Saqib
1057

See Details
Item Image

What is Between Operator in SQL ?Why use...

By Rizwan Saqib
717

See Details
Item Image

How and Why use Wild Card Character in S...

By Rizwan Saqib
899

See Details
Item Image

How to Replace Sub string in String

By Rizwan Saqib
970

See Details
Item Image

How Return Location of sub string in Str...

By Rizwan Saqib
797

See Details
Item Image

What is Cross Join ??Why use cross join ...

By Rizwan Saqib
969

See Details
Item Image

How count Difference Between Two date Us...

By Rizwan Saqib
905

See Details
Item Image

Why use Left ()Function in SQL Server

By Rizwan Saqib
954

See Details
Item Image

How to remove Spaces Left and Right side...

By Rizwan Saqib
921

See Details
Item Image

How Improve Execution time of Queries

By Rizwan Saqib
726

See Details
Item Image

5 Tips Speed up SQL Queries

By Rizwan Saqib
900

See Details
Item Image

How delete Duplicate Rows in Table

By Rizwan Saqib
747

See Details
Item Image

How find Max salary of Each Department

By Rizwan Saqib
980

See Details
Item Image

How to get First Row of Each group in a ...

By Rizwan Saqib
966

See Details
Item Image

How convert data types using Convert () ...

By Rizwan Saqib
910

See Details
Item Image

How to cast data types

By Rizwan Saqib
766

See Details
Item Image

Advantages and Workings of DBMS

By Rizwan Saqib
976

See Details
Item Image

What is trigger in database?

By Arsal Ahmed
910

See Details
Item Image

Normalization in SQL Server

By Rizwan Saqib
856

See Details
Item Image

Introduction about keys in SQL Server

By Rizwan Saqib
755

See Details
Item Image

What is SQL Intersect ??

By Rizwan Saqib
824

See Details
Item Image

What is SQL Reporting services (S.S.R.S)...

By Rizwan Saqib
822

See Details
Item Image

What is store Procedure ??

By Rizwan Saqib
836

See Details
Item Image

What is View and how can write view ,upd...

By Rizwan Saqib
684

See Details
Item Image

What is common Table Expression ?Why use...

By Rizwan Saqib
843

See Details
Item Image

What is trigger and Types of trigges

By Rizwan Saqib
989

See Details
Item Image

Union and Union all In SQL Server

By Rizwan Saqib
950

See Details
Item Image

Microsoft SQL Server Joins

By Rizwan Saqib
819

See Details
Item Image

Types Of database

By Rizwan Saqib
946

See Details
Item Image

How to use cursor in sql server and upda...

By Adil Shahbaz
932

See Details
Item Image

History Of DataBase

By Rizwan Saqib
997

See Details
Copyright Future Minutes © 2015- 2025 All Rights Reserved.   Terms of Service  |   Privacy Policy |  Contact US|  Pages|  Whats new?
Update on: Dec 20 2023 05:10 PM
Invite Colleagues

Enter an email address to invite a colleague or co-author to join you on socimo. They will receive an email and, in some cases, up to two reminders.

Send Message
Login
Login Required
Please login if you registered For this Action.
Login
Login
Login Required
Please login if you registered For this Action.
Login