as I develop new databases, i always find myself fine tuning my naming conventions and re-organising my objects based on schemas. it would be nice to have a right click option to change the schema much more quickly.
For example, instead of writing the following statement
ALTER SCHEMA HumanResources TRANSFER Person.Address;
i would just right click Person.Address >> Change Schema >> (and then pick HumanResources from a list)
being able to select multiple objects and do this would be a bonus1 vote
When Ordering by column numbers, formatting the SQL would replace the column number with the qualified column name. e.g.
Order By 1,2,3,4 would be come
Order By t.TerritoryName,
Renaming column aliases is not working and it might be very useful feature. Lets see following example:
FROM (SELECT 5 AS Sales) AS Totals
If You press F2 on table alias [Totals] it works perfectly. However if You need to change alias of column [Sales] and You will press F2 nothing happens beside proper highlighting of this column name.2 votes
My suggestion is to add support for Smart Rename of a database. It would update objects (procedures, views, functions, etc) that reference fully qualified objects. This would be very handy when database name changes due to new naming standards or other reasons.1 vote
Being able to have Smart Rename also generate a synonym of the old name, pointing to the object with the new name, would be very useful in scenarios where there is external code pointing to specific database objects that you're renaming.1 vote
For example, if table Person has Person_ID, and table Employee also has Person_ID which has a foreign key relationship to Person.Person_ID, then I smart-rename Person.Person_ID, it would be spectacular if Employee.Person_ID was also similarly renamed.1 vote
**BUG** - I ran a smart rename on all of my tables to change from TableName to tblTableName. I did this for ~15 tables and everything looked fine until I ran the code. Many of my stored procedures us cursors, and I found that none of my cursors were updated with the new table names.
SET @myCursor = CURSOR FOR SELECT MyField FROM dbo.MyTable WHERE MyFlag = 1
Run [Smart Rename...] on MyTable to change it to tblMyTable.
Notice that the cursor definition does not get changed.4 votes
When one would like to smart rename a column, the smart rename function does not update a MERGE statement. Could this be added to the smart rename feature?11 votes
sometimes I need to just change the casing of letters in a field name (e.g. a field has GUID and I want to make it Guid). smart rename does not allow me to change the name if the new name is exactly the same saying that a column with this name already exists.
so I change the name to GuidXXXX and then on the generated script remove the XXXX and the script runs just fine.
I think smart rename should not warn that the name exists if I am just changing casing of the name6 votes
Please add an option to propogate a name change down through the dependency hiearchy. If I change a column name, I would prefer the view/function not keep the old name as an alias, even if this means my rename script will have to touch many more items.
I would hope this could work similar to SQL Compare where there is an additional check box to script dependent items.
Smart rename is great, but I don't want to have to run it multiple times to rename a single column across all of my objects.3 votes
How about when doing a Smart Rename you offer a Just Do It (all apologies to Nike!) button? Clicking on this would run the script in the background using OSQL/SQLCMD/whatever and do the rename.
Often if I am doing a lot of renaming I have a lot of scripts open and I’m uncertain as to whether or not I’ve run them or not.
You can still warn people, although I would be happier if this was a configurable option (‘Warn before using Just Do It button in Smart Rename’)3 votes
I want to be able to rename objects that appear in strings within a script. For example, if I am renaming dbo.sometable, I want it to see and update a script that contains "Exec sp_someproc 'dbo.sometable'".4 votes
THe schema list in smart rename is currently unsorted, it would be a lot quicker to use (when changing an objects schema) is this were sorted alphabetically.2 votes
Self explanatory... Need to right-click a user-defined schema and be able to generate a script that effects the scema rename and code within all affected objects. Would be great to add a list of additional databases in which to look for candidate objects to change: triggers, SPs, UDFs...9 votes
SqlPrompt smart rename is a good refactor tool.
With the new xml columns we often store some "relational" data inside them.
xml data has implicit schema definition, and modifying a tag name should modify the name for all existing data in the same column.
For explicit schema definition this is very easy.1 vote
I do all of my work in script and would like the option to "Smart Rename" references in my open scripts rather than just installed objects.2 votes
Enhance Smart Rename to accept a list of name changes.
Even if it runs the existing smart rename and concatenates the scripts it would save a lot of data entry time versus doing each change one at a time.
You should require fully qualified names in the import data to avoid ambiguity errors.45 votes
Smart Rename should find and resolve external database dependencies.5 votes
- Don't see your idea?