Dropping Table or Deleting query

When we execute any query in SQL then if we write that same query again with some changes then message comes that it already in Database, So how can we delete old one to execute new query?

 look into this example:

CREATE TABLE STUDENT(std_id int);
Drop table student;    // Table is dropped...
CREATE TABLE STUDENT (std_id  int  Primary Key);