Add column to SQL Server

Question

I need to add a column to my SQL Server table  Is it possible to do so without losing the data  I already have

User · Answer

Use this query   ALTER TABLE tablename ADD columname DATATYPE size     And here is an example   ALTER TABLE Customer ADD LastName VARCHAR 50

User · Answer

Of course  Just use the ALTER TABLE    syntax    Example  ALTER TABLE YourTable   ADD Foo INT NULL   Adds a new int column existing rows will be                       given a NULL value for the new column     Or  ALTER TABLE YourTable   ADD Bar INT NOT NULL DEFAULT 0    Adds a new int column existing rows will                                     be given the value zero     In SQL Server 2008 the first one is a metadata only change  The second will update all rows    In SQL Server 2012  Enterprise edition the second one is a metadata only change too

User · Answer

Adding a column using SSMS or ALTER TABLE    ADD will not drop any existing data

User · Answer

Add new column to Table  ALTER TABLE  table  ADD Column1 Datatype   E g  ALTER TABLE  test  ADD ID Int   If User wants to make it auto incremented then   ALTER TABLE  test  ADD ID Int IDENTITY 1 1  NOT NULL

User · Answer

Add new column to Table with default value   ALTER TABLE NAME OF TABLE ADD COLUMN NAME datatype DEFAULT DEFAULT VALUE

[sql-server-2008] Add column to SQL Server

Examples related to sql-server-2008