I am creating a database.  I want to insert a column in a particular place in the table structure.  Since there's no data in the table, I figured I could just dro the table and recreate it.  So, in SQLite Studio, I tried executing this query:

drop table payments;
CREATE TABLE payments (
    pkey           INTEGER            PRIMARY KEY AUTOINCREMENT,
    vendor_key      INTEGER           DEFAULT NULL,            
    person_key    integer             DEFAULT NULL,
    payment_date   DATE               NOT NULL,
    amount         DOUBLE             NOT NULL,
    check_number   INT (11)           DEFAULT NULL,
    purpose        TEXT               NOT NULL,
    allocation_key INTEGER            DEFAULT NULL,
    project_key    INTEGER            DEFAULT NULL,
    payment_method TEXT               NOT NULL,
    budget_key     [INTEGER UNSIGNED] DEFAULT NULL,
    fund_key       INTEGER            DEFAULT NULL
);

I get an error saying the table "payments" already exists.  I tried wrapping the DROP TABLE line in a transaction, but I got the same error.  What do I have to do to get this to work?

(Yes, I know I can run the two statements separately, but I think there's something I should know about SQlite that this illustrates, and I'd like to know what that is.)

P.S.  Is there a guide to the use of markdown?  I had to use plain text in this message because the query did not appear on separate lines.