Parse_Syntax_Error Help

melodiesd
New Contributor

Hello all, 

I'm new to Databricks and can't figure out why I'm getting an error in my SQL code.

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

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?