Re: Rename table without breaking sp?

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 08/06/04

Next message: Chris Hohmann: "Re: Rename table without breaking sp?"
Previous message: Aaron [SQL Server MVP]: "Re: Rename table without breaking sp?"
In reply to: jason_at_catamaranco.com: "Rename table without breaking sp?"
Next in thread: jason_at_catamaranco.com: "Re: Rename table without breaking sp?"
Reply: jason_at_catamaranco.com: "Re: Rename table without breaking sp?"
Messages sorted by: [ date ] [ thread ]

Date: Fri, 6 Aug 2004 14:10:21 -0400

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

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
<jason@catamaranco.com> wrote in message
news:OrVSi59eEHA.1604@TK2MSFTNGP11.phx.gbl...
> What is the best way to rename a table without breaking esxisting Stored
> Procs that are dependent on the table....?
>
> Thanks
> Jason
>
>

Next message: Chris Hohmann: "Re: Rename table without breaking sp?"
Previous message: Aaron [SQL Server MVP]: "Re: Rename table without breaking sp?"
In reply to: jason_at_catamaranco.com: "Rename table without breaking sp?"
Next in thread: jason_at_catamaranco.com: "Re: Rename table without breaking sp?"
Reply: jason_at_catamaranco.com: "Re: Rename table without breaking sp?"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: rewriterule + image name
... rename the generic one and still display the same image under ... It think you mean the reverse? ... ..htaccess ErrorDocument as a php file that generates the missing image ...
(comp.lang.php)
Re: If Im going to be "Flamed": it may as well beTHIS group.
... don't know if this will assist but it's easy to reverse if it doesn't ... and then click Rename. ... Start Outlook Express. ... > Tonight I decided to open OE6, empty the Inbox AND Deleted Items. ...
(microsoft.public.windowsxp.perform_maintain)
Re: [PATCH 1/1] Replace down_trylock() with down_try(), reverse return values.
... Or as ocfs2 put it ... "kernel 1, world 0". ... Rename it to down_try, and reverse ...
(Linux-Kernel)
Re: I cant recieve emails in my outlook express all of a sudden
... You could try this if you want, you can always reverse the procedure if not ... and then click Rename. ... > recieved, but they won't load. ... > mircrosoft problem or server problem....Any help would be ...
(microsoft.public.windowsupdate)
Re: Renaming Stored Prcedures via EM
... Use sp_rename in Query Analyzer; it doesn't get confused the way EM does. ... (Reverse address to reply.) ... "Guadala Harry" wrote in message ... > on the sp name and then selecting Rename from the pop up menu. ...
(microsoft.public.sqlserver.programming)