SQLRefactor - SMART RENAME - Table with SchemaBound View

Refactors and formats SQL code.

SQLRefactor - SMART RENAME - Table with SchemaBound View

Postby pkayley » Wed Aug 18, 2010 5:58 pm

I've not had much cause to use SMART Rename feature within my Toolbelt until now - but what a brilliant utility this is

I did encounter one problem however - when trying to rename a table which was used in a View with SCHEMABINDING.

This prevented the table from being renamed and meant that the transaction rolledbac.

I was Simply able to overcome this by scripting & dropping the offending view -

But as an enhancement it may be worthwhile including in the WARNINGS TAB any SCHEMA Bound Views - on the 2nd page of the WiZARD.

Thanks for another time-saving goody from Redgate
Posts: 1
Joined: Wed Aug 18, 2010 5:47 pm

Postby james.billings » Thu Aug 19, 2010 6:14 pm

Glad you found the way around the problem, and I'll certainly add a request as per your description. Thanks for letting us know!
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Refactor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests