sql server db object create script -

sql server query generate script database when pattern matches. instance script out database objects has "customer". environment has few different database.

testdb proddb qatdb dbshare customereurope customerna customerap customeranz

let's have table, function, view, stored procedure has name v_customer_na_dbshare view or f_customereurope_qatdb. have script creates these 2 objects in dbshare & qatdb respectively.

please guide me. thank you.

right click on database -> tasks -> generate script.
there can choose objects contain word customer.
can identify them following script:

select * sys.objects name '%customer%'