Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159

    Unanswered: Does the object ID always change?

    Is there a case when dropping and recreating an object, for example a stored procedure, that the object ID doesn't change?

    I know the CRDATE changes and as far as I can tell the object ID changes, but is there a case when it doesn't?

    Richard.

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    No, except if your're playing with the system tables or... when you're reloading a dump older than your drop !

Posting Permissions

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