-1

I would like to check if there is a table in my MySQL database, which has a column called country. If so, I would like to know the table name / entity of it.

Is that possible?

Reza Saadati
  • 1,224
  • 13
  • 27
  • 2
    Read https://dev.mysql.com/doc/refman/8.0/en/columns-table.html , write query. If you don't have permission get somebody who has to write query, – P.Salmon Oct 06 '19 at 14:34

1 Answers1

1
show tables from database like 'country';

Using like to have the exact match, if your query returns result that means there is a table else there isn't.

Danyal Sandeelo
  • 12,196
  • 10
  • 47
  • 78