Drop, Create, Select in a Definition?

Is it possible to Drop a table, Create a table from a query, then Select from that table all within a Definition? When I try to reference the definition, I get this, referring to my DROP table command..

no viable alternative at input '(\n\nDROP' [Execution ID not available]
1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Jonathan ,  definitions must be comprised of a single SELECT statement, so, unfortunately, this is not possible. 

    Like
Like Follow
  • 5 mths agoLast active
  • 1Replies
  • 49Views
  • 2 Following