How to check if the table exists before inserting data?

Question

How to make such as: IF (table if exists types) THEN ... END ?

search for your title on google and you will find tons of solutions to your question — Lelio Faieta, May 28 '18 at 13:37
Possible duplicate of [Check if table exists in SQL Server](https://stackoverflow.com/questions/167576/check-if-table-exists-in-sql-server) — Mohamed Thasin ah, May 28 '18 at 14:16

score 0 · Answer 1 · answered May 28 '18 at 13:38

0

Try this:

SELECT COUNT(*)
FROM information_schema.tables 
WHERE table_schema = '[database name]' 
AND table_name = '[table name]';

Save the result and you can use it in an if statement

answered May 28 '18 at 13:38

Snipezzzx

1 Answers1