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

  • November 1, 2013 at 9:40 am

    #1663468

    The script is used to deploy code and data objects to our customers, and contains several objects entirely contained within a TRY/CATCH block. The script is designed to be run as a whole whether or not the customer has run it before.

    The purpose of the script is not to rename the column, but rather to build the necessary objects. We just want to change the name as part of the process.