Loading

update large table columns same value

Thulasiram pakala

8y760

i Have large no of tables in my database i am searching for a column name country dont know whichntable contatins column i need to find out table column and update the column value particulat value like country usa place update ind large tables any body help this query

2 Replies

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

Manish Kumar8y ago
Another Approach.

select b.name as table_name,a.name as column_name from sys.columns a inner join sys.tables b on a.object_id=b.object_id

where a.name like '%country%'

0
Ankit Sharma8y ago
Hi,

Please try the below query and let me know if it works for you
select * from INFORMATION_SCHEMA.COLUMNS
where COLUMN_NAME like '%country%'
order by TABLE_NAME
This will help you find the table name containing colum.
Once you have the table name, you easily update it
0