Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007

    Unanswered: Creating a table using LIKE

    Can a table be created using LIKE if the principal table has an identity column that is generated by a sequence?

    For example, Table A has a primary key that is generated by a Sequence. If I wanted to created a copy of Table A using LIKE, would I use "INCLUDING IDENTITY" or would I have to generate a new Sequence for the copy?


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    Why don't you try it in your test environment and see what happens. Then let us know.


Posting Permissions

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