AndrewChamp · November 17, 2022 12:32
diff --git a/search_database_tables_for_column_name.sql b/search_database_tables_for_column_name.sql
 # SEARCH DATABASE TABLES FOR COLUMN NAME

 SELECT 
    table_name, 
    column_name, 
    data_type,
    ordinal_position
 FROM  
 	INFORMATION_SCHEMA.COLUMNS 
 WHERE 
 	table_schema = 'change_database_name' 
 	AND column_name LIKE '%change_column_name%';
	# SEARCH DATABASE TABLES FOR COLUMN NAME

	SELECT
	table_name,
	column_name,
	data_type,
	ordinal_position
	FROM
	INFORMATION_SCHEMA.COLUMNS
	WHERE
	table_schema = 'change_database_name'
	AND column_name LIKE '%change_column_name%';