Convert dependencies to point to View instead of Table

I currently have a SQL Server 2008 database in which I am planning to separate out some tables to other databases. I want to be able to replace all references to the separated tables from the original database using views. Is there a better way (other than manually changing all FK and SProc references) to switch all the dependencies to reference the view instead of the table?

Answers


Usually the best course is to rename the tables and then name the view what the table used to be named.


You can try using sp_rename to change the name of the tables. I don't know if this will change your references also.


Need Your Help

Using Header as download link in PHP

php header http-headers

So I am having this problem wit my download link. Basically my previous way of creating download link is to just have a form button with method='link' and the action to be the link to the file. This

Print skipping newline

python multithreading newline

I've got a question based off an answer I saw. It uses a thread pool to manage threads but each thread prints 'Going to sleep... i', sleeps for i time and then prints 'Slept..'. my question is why it