Answer: Syntax:-
ALTER TABLE {TABLENAME}
ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL}
CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}
For Example:-
ALTER TABLE Employee_Master
ADD Employee_Code VARCHAR(20)
CONSTRAINT DF_Employee_Master_Employee_Code DEFAULT '' NOT NULL
Asked In: Many Interviews |
Alert Moderator