Question
Abhinav530 on Wed, 29 Jan 2020 19:09:30
Hello,
I want to create a external data source, but before i do that i need to like if exists then not create. if does not exists then create.
what is the system object or the query that i can check if the data source already exists.
Thanks,
Rahul
Replies
Nandan Hegde on Fri, 31 Jan 2020 06:53:45
Hello Abhinav,
You can execute the below query:
Select * from sys.external_data_sources
to get the list of external data source present.
So based on if not exists scenario , you can develop your code
NavtejSaini-MSFT on Fri, 31 Jan 2020 20:33:14
Hi Abhinav
Please let us know if you need further help with your question.
Thanks
Navtej S