Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    144

    Unanswered: Duplicate a table with SQL Command

    hey
    how can i duplicate a table with all record on it with a SQL Command?

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Duplicate a table

    Quote Originally Posted by bono56
    hey
    how can i duplicate a table with all record on it with a SQL Command?
    CREATE table mytable_copy AS
    SELECT * from originaltable ;

Posting Permissions

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