How to check empty table in sql query?

Question

I have two tables top1 and top2 .First I want to check top1 is empty or not.If top1 is not empty then truncate top2 and insert data from top1. Otherwise dont do any action .

CASE
WHEN top1 is not empty THEN
 Truncate top2
  Insert from Top1

END case

SELECT COUNT(*) FROM table_name if this return 0 means your table is empty. — Hamza Zafeer
– Hamza Zafeer, Commented May 11, 2016 at 14:31

Giles Thomas · Accepted Answer · 2016-05-11 15:11:48Z

1

Something like the below should do the trick. Provided both of the tables have the same structure....

IF EXISTS(SELECT 1 FROM top1) THEN
  TRUNCATE TABLE Top2;
  INSERT INTO top2 SELECT * FROM top1;
END IF;

edited May 11, 2016 at 15:11

Giles Thomas

5,8952 gold badges37 silver badges53 bronze badges

answered May 11, 2016 at 14:54

AntDC

1,93715 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

AntDC Over a year ago

I reallly cannot see what would not work about it. Perhaps you could supply details of the error?

Collectives™ on Stack Overflow

How to check empty table in sql query?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related