Results 1 to 2 of 2

Thread: Add fields to a table?!

  1. #1
    Join Date
    Oct 2002
    Posts
    4

    Question Add fields to a table?!

    I'm quite new to SQL-programming.

    I know how to create a table, with certain fields.
    My question is: Is it possible to add new fields to an existing table after you've created it, or do you have to make a completely new table?!

    I know about the UPDATE - SET, but those only changes the values in the table. I wan't to change the properties of the table in an easy way!

    /Erik

  2. #2
    Join Date
    Sep 2002
    Location
    Amsterdam
    Posts
    53
    ALTER TABLE table1
    ADD COLUMN ...


    see BOL for syntax

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •