SmartRename misses dependencies

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

SmartRename misses dependencies

Postby George Palacean » Wed Jan 21, 2009 12:18 pm

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
George Palacean
 
Posts: 19
Joined: Wed Jan 14, 2009 3:26 pm

Postby eddie davis » Fri Jan 23, 2009 4: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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests