python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions