Convert dependencies to point to View instead of Table

Posted by jwarzech on Stack Overflow See other posts from Stack Overflow or by jwarzech
Published on 2010-05-21T17:07:11Z Indexed on 2010/05/21 17:10 UTC
Read the original article Hit count: 184

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?

© Stack Overflow or respective owner

Related posts about database

Related posts about sql-server