Does anyone know if it is possible to create a new view based on an entity in another database (cross-database view)?
Yes, it is possible to create View base on Entity from different database schema.
For how to modeling in details, you can visit below page.
Thank you for using Visual Paradigm.
I was hoping to be able to create a view based on another database, not on another schema/owner. In Microsoft SQL Server I can create a view based on another database. So, the fully qualified column name in my view would be Database.Owner.Table.Column.