Adding new fields (columns) with SQL Server.....?

Discussion in 'Databases' started by JEP_Dude, Feb 18, 2010.

  1. #1
    Hey there.....

    I've run into problem and I need to add a few columns to a table using SQL Server 2008.

    I have absolutely NO idea how to do this. Can this be done? If so, how? Would you please give step-by-step instructions if its not asking to much?

    If anyone could even give a suggestion that may even resolve this problem, it would be MUCH appreciated!

    God Bless

    JEP_Dude
     
    JEP_Dude, Feb 18, 2010 IP
  2. georgiivanov

    georgiivanov Member

    Messages:
    62
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    25
    #2
    If you are using SQL Server open "Query Analyser", for SQL Server 2005/2008 open "SQL Server Management Studio", connect using user/password and issue the following statement:

    ALTER TABLE table_name_here ADD new_column_name new_column_type

    replacing the lower case words with your details.
     
    georgiivanov, Feb 18, 2010 IP