How to check if TABLE exists before ALTER query?

Asked Aug 19 '20 at 07:07

Active Aug 20 '20 at 23:55

Viewed 282 times

Before adding (ALTER) new column to table I want to check if that table exists. Because app is crashing since table is not present and we tried to add column to it.

I tried "Alter table if exist table_name add column abc" but no luck.

I want to do this in 1 query.

edited Aug 20 '20 at 23:55

user4157124

2,809
13
27
42

asked Aug 19 '20 at 07:07

AVJ

Does [this](https://stackoverflow.com/a/1604121/5841306) (or the one just below this, in vote descendingly ordered) answer your question ? – Barbaros Özhan Aug 19 '20 at 07:19
1

Thanks for reply. That will give if table is exist but how to combine it with ALTER query is my main concern. – AVJ Aug 19 '20 at 08:00

How to check if TABLE exists before ALTER query?

0 Answers0