How to add column to table in TSQL ?

	ALTER TABLE table_name
	ADD column_name datatype
	-- example
	ALTER TABLE schClients.tSenders_
	ADD Confirmed BIT NOT NULL DEFAULT 0
	GO

view raw gistfile1.sql hosted with ❤ by GitHub

Syntax from msdn