Essential Books

Alter Column

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

Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

ALTER TABLE:
*ALTER TABLE
*Add Columns
*Drop Column
*Add Primary Key
*Drop Constraint
*Alter Column
*Add Constraint
Table Of Contents