Are you doing this for an upgrade script? You can just try to add the column and if it fails then it already exists. When we add columns or Foriegn keys we add them one at a time in our sql script so that if they aren't already there then they get added.