adding a column to an existing table

[Fyorl]

Is it possible to add a column to a table you\'ve already created? I\'ve got quite a big table with all the player stats on and I while I was creating it I forgot to add a hp column. Is there any way I can do this without, changing the name of the table and creating a new one? Because I don\'t want to then search through all my code, changing every instance where the old table name appeared. Also, if I add a column, will rows get added to it?

[shivabharat]

Try this

 

ALTER TABLE <table_name> add column (hp varchar(100))

[Fyorl]

danke