https://community.databricks.com/t5/data-engineering/parse-syntax-error-help/m-p/48235#M28261 <P>Hello all,&nbsp;</P><P>I'm new to Databricks and can't figure out why I'm getting an error in my SQL code.</P><P><SPAN>Error in SQL statement: ParseException: [PARSE_SYNTAX_ERROR] Syntax error at or near 'if'.(line 1, pos 0) == SQL == if OBJECT_ID('tempdb.#InitialData') IS NOT NULL ^^^ DROP TABLE #InitialData</SPAN></P><P>We run this code at my organization in Microsoft SQL so I know that code itself works, so why am I getting this error when I try to run it in a Notebook?&nbsp;</P> Wed, 04 Oct 2023 17:49:39 GMT melodiesd 2023-10-04T17:49:39Z https://community.databricks.com/t5/data-engineering/parse-syntax-error-help/m-p/48235#M28261 <P>Hello all,&nbsp;</P><P>I'm new to Databricks and can't figure out why I'm getting an error in my SQL code.</P><P><SPAN>Error in SQL statement: ParseException: [PARSE_SYNTAX_ERROR] Syntax error at or near 'if'.(line 1, pos 0) == SQL == if OBJECT_ID('tempdb.#InitialData') IS NOT NULL ^^^ DROP TABLE #InitialData</SPAN></P><P>We run this code at my organization in Microsoft SQL so I know that code itself works, so why am I getting this error when I try to run it in a Notebook?&nbsp;</P> Wed, 04 Oct 2023 17:49:39 GMT https://community.databricks.com/t5/data-engineering/parse-syntax-error-help/m-p/48235#M28261 melodiesd 2023-10-04T17:49:39Z