Find tables containing columns with a prefix

Asked

Viewed 17 times

1

Hello,

Is there any way to know in a mysql database which tables have columns that contain the word "commissario" ?

mysql sql

  • See the table INFORMATION_SCHEMA COLUMNS and use the clause WHERE COLUMN_NAME LIKE 'comissao%'.

  • sorry, I’m beginner.. can be more detailed in the code?

  • SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE 'comissao%'

  • Perfect! Thank you

No answers

Browser other questions tagged mysql sql

You are not signed in. Login or sign up in order to post.