SQL update large table column values

Question

i Have large no of tables in my database i am searching for a column name country dont know which table contatins column i need to find out table column and i need to update particular values in the columns use where condition in all the tables eg cloumn conaion (usa) in this i need to update (ind) in the all table columns

Laxmidhar Sahoo · Answer

sir The below code will give you the table names where column name in country SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME = 'country' when you get the table names can update in the cursor