-1

I have table called "emp_manager" in employees database in SQL. It has 300153 rows. I want to delete entire table in SQL. I used drop table emp_manager; but, it is taking time and server does not respond it.

Can anyone help me to delete this table ?

enter image description here

Mayur Surani
  • 13
  • 2
  • Truncate is also taking too much time and sql workbench is getting hang. Is there any other way around to delete table with 300000 rows ? – Mayur Surani Jul 03 '22 at 12:20
  • 1
    300 thousand rows isn't that much, so if it it takes soe much time is there much traffic n the server? – nbk Jul 03 '22 at 12:27

2 Answers2

0

You can use truncate table emp_manager

khalid btb
  • 19
  • 2
0

Maybe first delete the rows from that table by using Truncate command and then drop this empty table with drop table.

mario19088
  • 101
  • 6
  • Truncate is also taking too much time and sql workbench is getting hang. Is there any other way around to delete table with 300000 rows ? – Mayur Surani Jul 03 '22 at 12:23