Red Gate forums :: View topic - SQLRefactor - SMART RENAME - Table with SchemaBound View
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Refactor 1
SQL Refactor 1 forum

SQLRefactor - SMART RENAME - Table with SchemaBound View

Search in SQL Refactor 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
pkayley



Joined: 18 Aug 2010
Posts: 1

PostPosted: Wed Aug 18, 2010 6:58 pm    Post subject: SQLRefactor - SMART RENAME - Table with SchemaBound View Reply with quote

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
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1121
Location: My desk.

PostPosted: Thu Aug 19, 2010 7:14 pm    Post subject: Reply with quote

Glad you found the way around the problem, and I'll certainly add a request as per your description. Thanks for letting us know!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group