How can I write a sql query to check if a particular table exists in a database?

Question

I know how to use queries but I've never had to use one for this particular tasks .. I know about the SHOW TABLES; command .. How can I write a query to check if a particular table exists in a MYSQL database .. For example , a query that checks if table MEMBERS exists in database called USERS ??

Russ Cam · Accepted Answer · 2013-01-31 20:03:21Z

2

You can use INFORMATION_SCHEMA.TABLES

USE USERS;
SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'MEMBERS'

answered Jan 31, 2013 at 20:03

Russ Cam

126k34 gold badges211 silver badges275 bronze badges

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

Comments

Gil Peretz · Accepted Answer · 2013-01-31 20:05:00Z

2

Searching Table:

select * from information_schema.tables where table_name like '%MEMBERS%'

Searching Column:

select * from information_schema.columns where table_name like '%COLUMN%'

answered Jan 31, 2013 at 20:05

Gil Peretz

2,4297 gold badges29 silver badges45 bronze badges

Collectives™ on Stack Overflow

How can I write a sql query to check if a particular table exists in a database?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related