Insert column into an existing table!

[roaddog]

Hello all.

So recently I always use SQL for storing data. Sometimes i want to insert a new column into an existing table if I want to update table, but the only way i can seem to do that is if i drop the table and re-create the table with the added column which results in all the data in the table being lost. I was wondering if anyone knows how to add a column to the table without having to drop it and re-create it?

Thanks

[TAPL]

Use ALTER.

http://www.w3schools.com/sql/sql_alter.asp

[roaddog]

Thanks TAPL

[TAPL]

You're welcome.