Find all tables containing column with specified name

0 comments
SELECT COLUMN_NAME, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%topup%'
Inline images 1Useful when working with a database you don't know much about.
SQL

Comments


Leave a Comment