Setting up daily database backups >>

Common date/time formats >>

SQL Server - SQL Table Basics - Altering/Adding Columns

Adding column

You can add new columns to an existing table. .

ALTER TABLE [dbo].[phone]
ADD   inactive_date DATETIME NULL  

GO

Alter column

You can add modify an existing column

ALTER TABLE [dbo].[person]
ALTER COLUMN [lastname] VARCHAR(35) NULL

GO