Home Forums SQL Server 2005 T-SQL (SS2K5) IF table exists, DROP TABLE then CREATE TABLE - script not working RE: IF table exists, DROP TABLE then CREATE TABLE - script not working

  • I found a MS reference that states:

    "DROP TABLE and CREATE TABLE should not be executed on the same table in the same batch. Otherwise an unexpected error may occur."

    and also:

    "A table cannot be changed and then the new columns referenced in the same batch."

    Now I just have to figure out how to accomplish this given the restrictions.

    Thanks for looking, though.

    ~ Jeff