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 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..
|