Wednesday, 11 February 2015

Constraint to Add in the Existing Column

ALTER TABLE PRDDOL.T_NAME
ADD CONSTRAINT DF_T_NAME_DATEUPLOADED
DEFAULT GETDATE() FOR DATEUPLOADED

References:

http://sqlserverplanet.com/ddl/add-column-default-value

No comments:

Post a Comment