SmartRename misses dependencies
George Palacean
Posts: 28
If a view references a table using the three-part identifier (even if it's in the same database), then it will not be changed when smartrenaming the table.
Ex:
create view testview
as
select * from databasename.dbo.tablename
but it works if the view is defined like this:
create view testview
as
select * from dbo.tablename
Ex:
create view testview
as
select * from databasename.dbo.tablename
but it works if the view is defined like this:
create view testview
as
select * from dbo.tablename
Comments
I have tested as per your example and replicated your problem.
I have created a Bug Report for the development team to consider. The reference for the Bug Report is SR-590. Hopefully the development team will rectify this bug in a future version of SQL Refactor.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com