Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    16

    Unanswered: can i add columns to existing tables?

    hey guys,

    can i add columns to existing tables or do i have to know all of my columns for the table(s) when i create it?

    this sounds like a simple question to answer, but so far i can't find the answer.

    thanks.

  2. #2
    Join Date
    Nov 2003
    Location
    Poland
    Posts
    7

    Re: can i add columns to existing tables?

    all what you need to do is call alter table <table_name> ADD COLUMN <column_name> <column_type>;

    example:
    alter table address ADD COLUMN city VARCHAR(30);


    Originally posted by Joshua_F
    hey guys,

    can i add columns to existing tables or do i have to know all of my columns for the table(s) when i create it?

    this sounds like a simple question to answer, but so far i can't find the answer.

    thanks.

  3. #3
    Join Date
    Sep 2003
    Posts
    16
    thank you very much!

Posting Permissions

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