CODEWITHSUNDEEP
sqlazureview
pepr
pepr

Reputation: 20770

Azure SQL: Is it possible to use the view from another database?

Being new to Azure SQL, I am already successfully JOINing my table with the table from the other database (by defining the CREATE EXTERNAL TABLE and the related things). However, some queries contain views from the other database, not the tables. How can I join my table with that external view? Is it possible at all? Or do I have to copy the code from the remote view and work directly with the external tables?

Upvotes: 1

Views: 2546

Answers (1)

Viorel Grafu
Viorel Grafu

Reputation: 129

with create external table you can access a table or view :

take a look at https://medium.com/@fbeltrao/access-another-database-in-azure-sql-1afc526b7ad4

Upvotes: 1

Related Questions