I have two existing duplicate databases (say Customers & CustomerPrev) in Azure one of which is newer then the other.
I have another Azure database that I want to query the other two. I've created an external table for the first one but I can't create the external table for the other db as the name already exists.
Can I use different names for external tables? If so, how do I match them up to the actual table?
Thanks