title: Create table but Drop it if the table exists already
body: <p>I am working on a request where I have to create a table to insert some data. So, obviously I will have first have a delete table st. before the create st. but when I am running this for the first time(before the table can be created) it will pop up an error saying table not created and then creates table and goe son from here. So every time any one runs my code for the first time it will pop up this error at drop table st. Does any one have any better idea??  </p>
  
  <p>Some thing like " if table exists then drop else create table"<br>
  I am not sure how are we going to do this in sql</p>
  
  <p>Drop table table_name;--------------> here it throws an error for the first time saying table does not exist.</p>
  
  <p>Create table table_name</p>
  
  <p>{ so on };</p>
  
  <p>By the way I am working on Teradata but a simple sql logic would help.</p>