i need to delete the data from all the tables where a column appears
Eg column_name = ABCD
Now i do get all the tables where a column like ABCD appears and stores it
in another table say temp
There are around 800+ tables i get
so my temp table has two fields
table_name column_name
now i want to delete data from these tables based upon condition
so my query is
Now taking the table_name from temp table in a cursor
how do i pass the table_name dynamically or using as variable in a cursor
eg: delete from @table_name where some condition