Professional Web Applications Themes

Rename table without breaking sp? - ASP Database

What is the best way to rename a table without breaking esxisting Stored Procs that are dependent on the table....? Thanks Jason...

Sponsored Links
  1. #1

    Default Rename table without breaking sp?

    What is the best way to rename a table without breaking esxisting Stored
    Procs that are dependent on the table....?

    Thanks
    Jason


    Sponsored Links
    Guest

  2. #2

    Default Re: Rename table without breaking sp?

    ALTER the stored procedures at the same time, or don't rename the table.

    If you rename the table, the stored procedures aren't going to magically
    re-write themselves.

    --
    [url]http://www.aspfaq.com/[/url]
    (Reverse address to reply.)




    <jasoncatamaranco.com> wrote in message
    news:OrVSi59eEHA.1604TK2MSFTNGP11.phx.gbl...
    > What is the best way to rename a table without breaking esxisting Stored
    > Procs that are dependent on the table....?
    >
    > Thanks
    > Jason
    >
    >

    Aaron [SQL Server MVP] Guest

  3. #3

    Default Re: Rename table without breaking sp?

    Another option is to rename the table and create a view with the old table
    name that points at the new table.

    --
    [url]http://www.aspfaq.com/[/url]
    (Reverse address to reply.)




    <jasoncatamaranco.com> wrote in message
    news:OrVSi59eEHA.1604TK2MSFTNGP11.phx.gbl...
    > What is the best way to rename a table without breaking esxisting Stored
    > Procs that are dependent on the table....?
    >
    > Thanks
    > Jason
    >
    >

    Aaron [SQL Server MVP] Guest

  4. #4

    Default Re: Rename table without breaking sp?

    <jasoncatamaranco.com> wrote in message
    news:OrVSi59eEHA.1604TK2MSFTNGP11.phx.gbl...
    > What is the best way to rename a table without breaking esxisting Stored
    > Procs that are dependent on the table....?
    Database? Version? DDL? Sample Data?
    [url]http://aspfaq.com/5009[/url]

    How about creating a view/query with the name of the old table, based on the
    new table?


    Chris Hohmann Guest

  5. #5

    Default Re: Rename table without breaking sp?

    Thanks.

    "Aaron [SQL Server MVP]" <ten.xocdnartreb.noraa> wrote in message
    news:eD0dgC%23eEHA.3988tk2msftngp13.phx.gbl...
    > ALTER the stored procedures at the same time, or don't rename the table.
    >
    > If you rename the table, the stored procedures aren't going to magically
    > re-write themselves.
    >
    > --
    > [url]http://www.aspfaq.com/[/url]
    > (Reverse address to reply.)
    >
    >
    >
    >
    > <jasoncatamaranco.com> wrote in message
    > news:OrVSi59eEHA.1604TK2MSFTNGP11.phx.gbl...
    > > What is the best way to rename a table without breaking esxisting Stored
    > > Procs that are dependent on the table....?
    > >
    > > Thanks
    > > Jason
    > >
    > >
    >
    >

    Guest

  6. #6

    Default Re: Rename table without breaking sp?

    Thanks.

    "Aaron [SQL Server MVP]" <ten.xocdnartreb.noraa> wrote in message
    news:OZJJ6C%23eEHA.1424tk2msftngp13.phx.gbl...
    > Another option is to rename the table and create a view with the old table
    > name that points at the new table.
    >
    > --
    > [url]http://www.aspfaq.com/[/url]
    > (Reverse address to reply.)
    >
    >
    >
    >
    > <jasoncatamaranco.com> wrote in message
    > news:OrVSi59eEHA.1604TK2MSFTNGP11.phx.gbl...
    > > What is the best way to rename a table without breaking esxisting Stored
    > > Procs that are dependent on the table....?
    > >
    > > Thanks
    > > Jason
    > >
    > >
    >
    >

    Guest

  7. #7

    Default Re: Rename table without breaking sp?

    Thanks - sql server 8.0......3 foreign tables related...two stored
    procedures dependent.

    - Jason
    "Chris Hohmann" <nospamthankyou.com> wrote in message
    news:esblSE%23eEHA.704TK2MSFTNGP09.phx.gbl...
    > <jasoncatamaranco.com> wrote in message
    > news:OrVSi59eEHA.1604TK2MSFTNGP11.phx.gbl...
    > > What is the best way to rename a table without breaking esxisting Stored
    > > Procs that are dependent on the table....?
    >
    > Database? Version? DDL? Sample Data?
    > [url]http://aspfaq.com/5009[/url]
    >
    > How about creating a view/query with the name of the old table, based on
    the
    > new table?
    >
    >

    Guest

Similar Threads

  1. why is this breaking?
    By Jamesy in forum Dreamweaver AppDev
    Replies: 0
    Last Post: April 11th, 10:35 PM
  2. Breaking swf
    By albusd@mac.com webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 2
    Last Post: January 24th, 06:55 AM
  3. [PHP] rename()
    By Edward Peloke in forum PHP Development
    Replies: 0
    Last Post: September 11th, 08:44 PM
  4. rename()
    By Edward Peloke in forum PHP Development
    Replies: 0
    Last Post: September 11th, 07:21 PM
  5. Replies: 2
    Last Post: August 12th, 07:55 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139