Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Unanswered: Database Updation

    Hi All,

    I want to update my current database schema to a new database schema.
    However I want to retain my data.
    The new schema might have additions/deletions of tables/columns

    If anyone knows how to do it, let me know.

    Thanks,
    Scarlett

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Adding new tables will not affect your existing data.

    If you "delete" a table (note that tables are dropped not deleted), then of course you'll lose the data in that table.

    You can add columns to existing tables without losing data
    You can drop columns from tables without losing data in the other columns (you will of course lose the data in the column you drop).

    Check the manual for the ALTER TABLE command. This is what you will need (and of course DROP TABLE and CREATE TABLE)

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    why not COPY your schema, then you have a backup.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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