Confussion where objects have the same name

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Confussion where objects have the same name

Postby Niall » Tue Apr 24, 2012 8:47 am

We have a large Data Warehouse where there are stages to bringing the data in and we used schemas to designate the layer.

So for instance there is a Staging table in the schema Staging_something, as well as a view of the current data in Current_something, as well as another view that shows the history in the schema History_something. To keep life simple(ish) the tables and view have the same name, ie.

Staging_something.Account
Current_something.Account
History_something.Account

As it is a data warehosue with lots of feed systems we have a moderate amount of tables, views, etc, circa 3k objects.

SQL Prompt does not seem very happy with this and will when working on a query for History_something.Account 'pop up' with columns from Current_something.Account.

This appears to have been introduced recently as a bug and does greatly devalue the use of the tool for us.
Niall
 
Posts: 20
Joined: Wed Jul 21, 2010 9:15 am

Postby andy.campbell.smith » Thu Apr 26, 2012 10:24 am

We're having trouble reproducing this here - can you let us know at what point in writing the query you're seeing these suggestions pop up? Screenshots would be helpful - you can email them in to support@red-gate.com and we'll try and figure out what's going on. Thanks!
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests