Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    Virginia
    Posts
    13

    Unanswered: Creating backup table

    I am trying to create a single backup table, I am familiar with the create table function, but how do I use the function to create a duplicate table in my db.
    Roger W. Johnson Jr.


  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Re: Creating backup table

    Hello,

    use
    CREATE TABLE mybackup AS SELECT * FROM mytab
    where mybackup is the name of the backup table and mytab is the
    original table.

    Hope that helps ?
    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.com


    Originally posted by rwj7p
    I am trying to create a single backup table, I am familiar with the create table function, but how do I use the function to create a duplicate table in my db.

  3. #3
    Join Date
    Oct 2002
    Location
    Virginia
    Posts
    13

    Re: Creating backup table

    Originally posted by alligatorsql.com
    Hello,

    use
    CREATE TABLE mybackup AS SELECT * FROM mytab
    where mybackup is the name of the backup table and mytab is the
    original table.

    Hope that helps ?
    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.com
    Thanks, worked just fine. I knew I was close I was trying to put the select in () thats what my issue was.

    Thanks for your help
    Roger W. Johnson Jr.


Posting Permissions

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