topic Re: How to delete an sde file with  Python in Python Questions https://community.esri.com/t5/python-questions/how-to-delete-an-sde-file-with-python/m-p/50239#M3938 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This is what&nbsp; I did:</P><P></P><P><SPAN style="font-family: Consolas; font-size: small;"> </SPAN><SPAN style="color: #0000ff; font-family: Consolas; font-size: small;">if</SPAN><SPAN style="font-family: Consolas; font-size: small;"> </SPAN><SPAN style="color: #6f008a; font-family: Consolas; font-size: small;">os</SPAN><SPAN style="font-family: Consolas; font-size: small;">.</SPAN><SPAN style="color: #6f008a; font-family: Consolas; font-size: small;">path</SPAN><SPAN style="font-family: Consolas; font-size: small;">.exists(sdeFile):</SPAN></P><P><SPAN style="font-size: small; font-family: Consolas; ">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #008000; font-size: small; font-family: Consolas; "># removing the file using the os.remove() method</SPAN></P><P><SPAN style="font-size: small; font-family: Consolas; ">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #6f008a; font-size: small; font-family: Consolas; ">os</SPAN><SPAN style="font-size: small; font-family: Consolas; ">.remove(sdeFile)</SPAN></P></BODY></HTML> Tue, 25 Feb 2020 19:04:42 GMT JoseSanchez 2020-02-25T19:04:42Z How to delete an sde file with Python https://community.esri.com/t5/python-questions/how-to-delete-an-sde-file-with-python/m-p/50237#M3936 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>How can I delete an sde file located in my scratch space.</P><P></P><P></P><P>prefixOutputWorkspace = r"C:\scratch\....\ConnectionToSQL.sde"</P><P>if arcpy.Exists(prefixOutputWorkspace):<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; delete this sde conection </P><P>Recreate sde connection</P><P></P><P>Thanks</P></BODY></HTML> Tue, 25 Feb 2020 16:47:44 GMT https://community.esri.com/t5/python-questions/how-to-delete-an-sde-file-with-python/m-p/50237#M3936 JoseSanchez 2020-02-25T16:47:44Z Re: How to delete an sde file with Python https://community.esri.com/t5/python-questions/how-to-delete-an-sde-file-with-python/m-p/50238#M3937 <HTML><HEAD></HEAD><BODY><P>You can always use <A class="link-titled" href="https://docs.python.org/2/library/os.html#os.remove" title="https://docs.python.org/2/library/os.html#os.remove">15.1. os.remove() — Miscellaneous operating system interfaces — Python 2.7.17 documentation</A> to remove files on the file system.</P><P></P><P>Or, if you want to stay within ArcPy modules:&nbsp; <A class="link-titled" href="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/delete.htm" title="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/delete.htm">Delete—Data Management toolbox | Documentation</A>&nbsp;</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><SPAN style="color: #4c4c4c; font-family: 'Avenir Next W01', 'Avenir Next W00', 'Avenir Next', Avenir, 'Helvetica Neue', sans-serif; font-size: 15.9375px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">Deleting a database connection file does not delete the enterprise database. A database connection file is simply a shortcut to the database.</SPAN></BLOCKQUOTE></BODY></HTML> Tue, 25 Feb 2020 18:59:58 GMT https://community.esri.com/t5/python-questions/how-to-delete-an-sde-file-with-python/m-p/50238#M3937 JoshuaBixby 2020-02-25T18:59:58Z Re: How to delete an sde file with  Python https://community.esri.com/t5/python-questions/how-to-delete-an-sde-file-with-python/m-p/50239#M3938 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This is what&nbsp; I did:</P><P></P><P><SPAN style="font-family: Consolas; font-size: small;"> </SPAN><SPAN style="color: #0000ff; font-family: Consolas; font-size: small;">if</SPAN><SPAN style="font-family: Consolas; font-size: small;"> </SPAN><SPAN style="color: #6f008a; font-family: Consolas; font-size: small;">os</SPAN><SPAN style="font-family: Consolas; font-size: small;">.</SPAN><SPAN style="color: #6f008a; font-family: Consolas; font-size: small;">path</SPAN><SPAN style="font-family: Consolas; font-size: small;">.exists(sdeFile):</SPAN></P><P><SPAN style="font-size: small; font-family: Consolas; ">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #008000; font-size: small; font-family: Consolas; "># removing the file using the os.remove() method</SPAN></P><P><SPAN style="font-size: small; font-family: Consolas; ">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #6f008a; font-size: small; font-family: Consolas; ">os</SPAN><SPAN style="font-size: small; font-family: Consolas; ">.remove(sdeFile)</SPAN></P></BODY></HTML> Tue, 25 Feb 2020 19:04:42 GMT https://community.esri.com/t5/python-questions/how-to-delete-an-sde-file-with-python/m-p/50239#M3938 JoseSanchez 2020-02-25T19:04:42Z