[thelist] Help w/SQL Modify Table

[Palyne Gaenir]

Hi Evoltians,

I know this is SO basic, but amazingly enough, I've never had to do 
it, maybe because I've only been doing CFML for about 1.5 years.  I 
need to modify one of my tables -- add a column.  I'm searching 
Forta's book, my SQL book, and zillions of online tutorials.  There 
are a million versions of how to create a table, but I can't find an 
example of how to MODIFY one (in SQL Server).  I have lots of data in 
the table and I don't want to lose it.  I don't want to make a new 
table, call it into the new table, delete the old table, remake the 
old table right, call the data back in... I am super-pressed on a 
deadline that hits early tomorrow morning, have tons of work, and I 
am just flat out of time for finding this.  I am hoping that someone 
on this list will have mercy and just give me the code?  I promise to 
dredge up some useful tips as soon as this deadline passes.

Best regards,
Palyne