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

delete all tables from the database that...

By Junaid A
27

See Details
Item Image

restart sql services using command

By Junaid A
29

See Details
Item Image

The Programming Language Powering MS SQ...

By abrar arshad
251

See Details
Item Image

Search value in database and return tabl...

By Junaid A
210

See Details
Item Image

how to find changes in database

By Junaid A
282

See Details
Item Image

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

By Junaid A
230

See Details
Item Image

How to download SQL Server 2019

By Junaid A
224

See Details
Item Image

Error handline in sql script

By Junaid A
321

See Details
Item Image

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

By Junaid A
321

See Details
Item Image

The backend version is not supported to ...

By Junaid A
652

See Details
Item Image

check which sp has more lines

By Junaid A
320

See Details
Item Image

How to check which database table has mo...

By Junaid A
331

See Details
Item Image

how to check modification in ms sql data...

By Junaid A
238

See Details
Item Image

How To Solve MS SQL SERVER Saving Change...

By Ubaid ur Rehman
1524

See Details
Item Image

procedure to take most viewed products?

By Zaif Ullah
798

See Details
Item Image

procedure to take recent viewed products...

By Zaif Ullah
719

See Details
Item Image

procedure to take related products?

By Zaif Ullah
761

See Details
Item Image

procedure to take product by catagories?

By Zaif Ullah
656

See Details
Item Image

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

By Rizwan Saqib
776

See Details
Item Image

How Delete all Tables of database Record...

By Rizwan Saqib
863

See Details
Item Image

What is Aliases in SQL?

By Rizwan Saqib
957

See Details
Item Image

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

By Rizwan Saqib
622

See Details
Item Image

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

By Rizwan Saqib
812

See Details
Item Image

How to Replace Sub string in String

By Rizwan Saqib
858

See Details
Item Image

How Return Location of sub string in Str...

By Rizwan Saqib
692

See Details
Item Image

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

By Rizwan Saqib
858

See Details
Item Image

How count Difference Between Two date Us...

By Rizwan Saqib
807

See Details
Item Image

Why use Left ()Function in SQL Server

By Rizwan Saqib
859

See Details
Item Image

How to remove Spaces Left and Right side...

By Rizwan Saqib
807

See Details
Item Image

How Improve Execution time of Queries

By Rizwan Saqib
632

See Details
Item Image

5 Tips Speed up SQL Queries

By Rizwan Saqib
802

See Details
Item Image

How delete Duplicate Rows in Table

By Rizwan Saqib
645

See Details
Item Image

How find Max salary of Each Department

By Rizwan Saqib
872

See Details
Item Image

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

By Rizwan Saqib
857

See Details
Item Image

How convert data types using Convert () ...

By Rizwan Saqib
811

See Details
Item Image

How to cast data types

By Rizwan Saqib
668

See Details
Item Image

Advantages and Workings of DBMS

By Rizwan Saqib
871

See Details
Item Image

What is trigger in database?

By Arsal Ahmed
788

See Details
Item Image

Normalization in SQL Server

By Rizwan Saqib
770

See Details
Item Image

Introduction about keys in SQL Server

By Rizwan Saqib
691

See Details
Item Image

What is SQL Intersect ??

By Rizwan Saqib
768

See Details
Item Image

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

By Rizwan Saqib
757

See Details
Item Image

What is store Procedure ??

By Rizwan Saqib
769

See Details
Item Image

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

By Rizwan Saqib
617

See Details
Item Image

What is common Table Expression ?Why use...

By Rizwan Saqib
777

See Details
Item Image

What is trigger and Types of trigges

By Rizwan Saqib
887

See Details
Item Image

Union and Union all In SQL Server

By Rizwan Saqib
875

See Details
Item Image

Microsoft SQL Server Joins

By Rizwan Saqib
713

See Details
Item Image

Types Of database

By Rizwan Saqib
847

See Details
Item Image

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

By Adil Shahbaz
841

See Details
Item Image

History Of DataBase

By Rizwan Saqib
892

See Details
Copyright Future Minutes © 2015- 2024 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