SmartRename misses dependencies

Refactors and formats SQL code.

SmartRename misses dependencies

Postby George Palacean » Wed Jan 21, 2009 11:18 am

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.

create view testview
select * from databasename.dbo.tablename

but it works if the view is defined like this:
create view testview
select * from dbo.tablename
George Palacean
Posts: 19
Joined: Wed Jan 14, 2009 2:26 pm

Postby eddie davis » Fri Jan 23, 2009 3:28 pm

Thank you for your post into the forum and sorry that you have encountered this problem

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 Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1147
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Refactor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests