is there any simple way to run search across all the tables in couchdb?

mentax: tables? what is tables? :)

I assume u mean all the DBs?

If so, not without writing a script of some sort.

yes, seaerch in all dbs

fairly easy with bash I guess

here's an example of using a bash for loop to get all DB names and run a DELETE command on each, but you could replace the DELETE with a GET on a view or whatnot:

for i in `curl -su admin:CouCHpa22w0rd localhost:15984/_all_dbs | jq . | sed 's/"//g' | sed 's/,/ /g' | sed 's/]//g' | sed 's/\//%2F/g' | sed 's/_users//g' | sed 's/_replicator//g' | sed 's/\[//g'` ; do curl -su admin:CouCHpa22w0rd localhost:15984/$i -X DELETE | jq .; done

I'm sure that could be improved markedly without all the chained sed commands lol.