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