Post reply

Changing tables

  • April 24, 2003 at 7:43 am

    #159801

    I am new to Database Admin and I was wondering if there is a way to easy modify the table structure and keep the data. I have a client who insist on changing the table structures constantly

    Thanks

  • April 24, 2003 at 7:54 am

    #455187

    One alternative is to copy the data to a temporary table before modifying the structure, modify the structure of original table(Drop & Create), Issue INSERT INTO SELECT to repopulate the data from temporary table and then drop the temporary table.

    If you are doing the changes in enterprize manager, then it does the same explained above. This also gives an option to save changed script, which looks similar to the one explained above.

  • April 24, 2003 at 8:03 am

    #455200

    Thanks

  • April 24, 2003 at 8:10 am

    #455204

    If you make design changes in EM it will copy the date out, and back for you.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply