Add field to table

Posted on 2010-01-08
Last Modified: 2012-05-08
Can I add a new field to a table while people are using the database.  IE add a field while people are using the table live.
Question by:sbdt8631
    LVL 60

    Accepted Solution


    alter table tablename
    add columnname datatype

    LVL 10

    Expert Comment

    by:Rakesh Jaimini
    yes you can but do remember to modify all insert or update SPs on the same table
    LVL 60

    Expert Comment

    ...modify IF needed.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video discusses moving either the default database or any database to a new volume.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now