Loading

SQL update large table column values

Thulasiram pakala

8y714SQL

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo8y ago
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