mssql 刪除欄位

/*20130716 delete field*/
IF (select count(name) from syscolumns where id=(select id from sysobjects where name='book') and name='emp_id') > 0
BEGIN
  ALTER TABLE book DROP emp_id
END