SQL Refactor for Delete and/or move Suggestion

Refactors and formats SQL code.

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

SQL Refactor for Delete and/or move Suggestion

Postby unclebiguns » Thu Sep 30, 2010 4:20 pm

I came across an issue today where I needed to move 2 columns from table A to table B.

I assumed SQL Refactor would at least have a "Smart Delete" function that would find all references and either notify me or remove them from those objects. I was disappointed when it wasn't there. I think this would be a nice addition.

It would have been even better for me to have been able to do a "Smart Move" where I could select the table I want to move the columns to. This isn't a "Split Table" as the other table already exists.
Jack Corbett
http://wiseman-wiseguy.blogspot.com
SQL Server DBA
MCITP: Database Administration SQL Server 2008
unclebiguns
 
Posts: 11
Joined: Tue Apr 13, 2010 4:53 pm

Postby David Atkinson » Sat Nov 06, 2010 7:07 pm

Regarding 'smart delete', although we don't have this feature, we've got SQL Search, which is a free tool that will allow you to identify references in your databases.

In the upcoming release of SQL Prompt 5, we will have a 'find invalid objects' feature which will identify those objects that reference objects that have since been deleted or renamed. This should help you to clean your database once objects have been removed.

Kind regards,

David Atkinson
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests