use embshist go alter table FnmLoan add SellerCity char(50) not null default '#' go alter table FnmLoan add SellerState char(2) not null default '#' go alter table FnmLoan add ServicerCity char(50) not null default '#' go alter table FnmLoan add ServicerState char(2) not null default '#' go