/******************************************************
 *
 * Name:         basic-training-columns.sql
 *     
 * Design Phase:
 *     Author:   John Miner
 *     Date:     12-21-2012
 *     Blog:     www.craftydba.com
 *
 *     Purpose:  Create a series of articles on
 *               database developer (70-433) topics.
 *
 *     Topic:    Insert, update & delete columns.
 *
 ******************************************************/


--
-- Select training database
--

-- Which database to use.
USE [TRAINING]
GO


--
-- Modify publishers table 
--

-- Fails due to existing data
ALTER TABLE [PUBS].[PUBLISHERS]
ADD zip char(5) NOT NULL;


-- Works but choose wrong data type
ALTER TABLE [PUBS].[PUBLISHERS]
ADD zip int NULL;


-- Change the data type
ALTER TABLE [PUBS].[PUBLISHERS]
ALTER COLUMN zip char(5) NULL;


-- Remove the column
ALTER TABLE [PUBS].[PUBLISHERS]
DROP COLUMN zip;