How do you check a database table existence with query statement

Question

may i know how do you check if a database table already exist in the database already or not with just using the sql query method.

Possible duplicate of [Check if table exists in SQL Server](http://stackoverflow.com/questions/167576/check-if-table-exists-in-sql-server) — Izzy, May 02 '17 at 07:53

Rahul Sukhsohale · Answer 1 · 2017-05-02T08:02:45.313

0

Try this

IF Exist(Select 1 from INFORMATION_SCHEMA. COLUMNS where TABLE_NAME like '%tableName%')

edited May 02 '17 at 08:02

answered May 02 '17 at 07:56

Rahul Sukhsohale

1 Answers1