Best way to add a column to a table in SQLserver?

Discussion in 'Databases' started by marlinmapco, Dec 22, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. marlinmapco

    marlinmapco

    If i want to save my data in a table, what is the best (easiest) way to add a new column to a table?

    When i try to add a column in SQL server Man Studio i get a warning that the table need to be dropped/created unlike doing the same in VS2008 on a MDF table
     
    marlinmapco, Dec 22, 2008
    #1
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    The error that you are seeing is by design. Open your SSMS 08 - tools - options - designers - uncheck the box that states 'prevent saving changes that require table re-creation' . This will allow to recreate the a column


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
    JorgeR, Dec 22, 2008
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page