Add a columns with a default value in existing table in SQL Server

Add a columns with a default value in existing table in SQL Server.

Today's we working with database. My college  asked me how to add column using alter command and the added column not allow NULL value || allow NULL value. 

I have done the query using the ALTER TABLE command and ADD command. The code-sample as given below.

Two example.

1. Add a columns with a default value in existing table in SQL Server.
2.Column With Default Column Constraint to Table.

--Add a columns with a default value in existing table in SQL Server
ALTER TABLE DBO.MOBILEPREFERENCES
ADD
     CREATEDBY VARCHAR(150) NULL
    ,CREATEDATE DATETIME NOT NULL DEFAULT GETDATE()
    ,UPDATEDBY VARCHAR(150) NULL
    ,UPDATEDDATE DATETIME NULL DEFAULT GETDATE()
   
   
--Add Column With Default Column Constraint to Table
ALTER TABLE DBO.MOBILEPREFERENCES
ADD
     CREATEDBY VARCHAR(150) NULL
    ,CREATEDATE DATETIME NOT NULL DEFAULT GETDATE()
    ,UPDATEDDATE DATETIME NULL DEFAULT GETDATE()
CONSTRAINT DF_MOBILEPREFERENCES_PREFERENCES DEFAULT '' NOT NULL



ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

Add a columns with a default value in existing table in SQL Server. Add a columns with a default value in existing table in SQL Server. Reviewed by Anil Singh on 10:19 PM Rating: (5)
www.code-sample.com/. Powered by Blogger.
^