Add database name format specfication
vjacob1
Posts: 57 Bronze 1
in SQL Prompt
Is there a way to format SQL Prompt to add the database name in the FROM and JOIN Clauses
i.e instead of dbo.personnel - it would make it <database name>.dbo.personnel
I know that is being a bit strict but we write stored procedures that access data on the database server in a different database all the time as we cannot update the actual database as it is constantly changing and managed by our consultant.
Thanks,
Vinod Jacob
i.e instead of dbo.personnel - it would make it <database name>.dbo.personnel
I know that is being a bit strict but we write stored procedures that access data on the database server in a different database all the time as we cannot update the actual database as it is constantly changing and managed by our consultant.
Thanks,
Vinod Jacob
Tagged:
Answers
I understand the scenario and it would be pretty handy! however the only thing I can suggest is making a post here on the UserVoice and vote on it, from there the developers will look into the request.
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Thank you for the suggestion
I have added the idea to the UserVoice.