Column

Thêm cột:
ALTER TABLE TableName ADD ColumnName INT
VD: ALTER TABLE HocSinh ADD NgaySinh DateTime

Đổi tên cột:
The script for renaming any column :
sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

The script for renaming any object (table, sp etc) :
sp_RENAME '[OldTableName]' , '[NewTableName]'

(http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/)