Adding a Column to a Table

• harim

  SSC Journeyman

  Points: 98

  More actions

  February 24, 2003 at 12:37 pm

  #81511

  Can I add a column to a database table without dropping and recreating the table?

  The problem is that everytime a user creates an action that requires a new table - at the moment I drop the table and recreate the table with the new column.

  This requires lots of resources as I have to populate the table again.

  Is there a design way I can go around this?

  Thanks,

  Bianca

• jpipes

  SSChampion

  Points: 12230

  More actions

  February 24, 2003 at 12:41 pm

  #449622

  ALTER TABLE TableName

  ADD COLUMN column_name...

  It will add the column to the end of the field list...