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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.