>Is there a way to copy a view from one database to another, assuming the second database has all the necessary tables with all the right fields?
Open the view, right click to see the code, copy the code. Than in commnad window :
Open database dSecondDb
create sql view as
cetin

Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad