This is a Microsoft SQL tutorial demonstrating how to add, alter or remove columns on existing tables. This video shows the rules when performing these changes. There is also a note on dropping constraints.
Complimentary videos:
Creating tables: • MS SQL tutorial giving an introduction to ...
SSMS object explorer: • MS SQL tutorial on SSMS environment, how t...