add a new column with data

[Anon]

can anyone tell me how to add a new column with data (say, from outside file) to a existing table? thanks.

[[deleted]]

You mean add a new column and then populate it with data? Will the data be different for each row? If so, you would need to just add the column, then write a script to go through and update the table with the proper data. If the data will be the same (initially) for all the rows, then just set a default value on the column and it will set it on all your existing rows....

Matt Wade
codewalkers.com

[iifs044]

I think what you're looking for is:

ALTER TABLE table_name ADD new_col_name VARCHAR(25)

Substitute whatever datatype you want for VARCHAR(25).

-- Mitch