Hello,
There is an external data source created in the serverless sql pool.
How can I find out if this external data source is being used anywhere before deleting it?
Thank you
Hello,
There is an external data source created in the serverless sql pool.
How can I find out if this external data source is being used anywhere before deleting it?
Thank you
Hello @arkiboys ,
Thanks for the ask and using the Microsoft Q&A platform .
If you query the sys.external_tables DMV and join it to sys.external_data_sources you can query and see if any external tables are using it before you delete.
Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
Hi
How do I join them together?
select * from sys.external_tables --> returns 0 rows
select * from sys.external_data_sources --> returns 10 rows
Thank you
8 people are following this question.