List Of Tables Having The Column

we have seen the methods to check if column exists in a specific table in the database

 USE {{Database Name}}

SELECT

    TABLE_SCHEMA, TABLE_NAME

    FROM INFORMATION_SCHEMA.COLUMNS

    WHERE COLUMN_NAME = '{{Column Name}}'

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email