Creating a cross-database view

General Questions/Discussions
1

Does anyone know if it is possible to create a new view based on an entity in another database (cross-database view)?

2

Yes, it is possible to create View base on Entity from different database schema.

Screenshot
Screenshot1249×787 68.6 KB

For how to modeling in details, you can visit below page.

Thank you for using Visual Paradigm.

1 Like
3

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.

Thanks.