How to search for a specific column name in all the tables in MySQL Workbench - MySQL DBA Tutorial

How to search for a specific column name in all the tables in MySQL Workbench


explains what are different ways you can find out if the column exists in database or not for a table. You can query information_schema or you can use schema inspector to find out the column if it exits or does not exists in MySQL Server.


Query you can use to find out if column exists
SELECT
    table_name,
    column_name,
    data_type,
    ordinal_position
FROM  INFORMATION_SCHEMA.COLUMNS
WHERE table_schema = 'schema_name'
  AND column_name = 'Column_name' ;

MySQL Workbench Tutorial - How to check if column exists in MySQL Database

1 comment: