SQL Alter Column


Example

ALTER TABLE Employees
ALTER COLUMN StartingDate DATETIME NOT NULL DEFAULT (GETDATE())

This query will alter the column datatype of StartingDate and change it from simple date to datetime and set default to current date.