use embshist go alter table FhlLoan add ADR char(1) not null default '#' go alter table FhlLoan add NumADR int not null default -999 go alter table FhlLoan add TotDefAmt float not null default -999.0 go alter table FnmLoan add ADR char(1) not null default '#' go alter table FnmLoan add NumADR int not null default -999 go alter table FnmLoan add TotDefAmt float not null default -999.0 go