Red Gate forums :: View topic - Confussion where objects have the same name
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

Confussion where objects have the same name

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Niall



Joined: 21 Jul 2010
Posts: 20

PostPosted: Tue Apr 24, 2012 8:47 am    Post subject: Confussion where objects have the same name Reply with quote

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



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Thu Apr 26, 2012 10:24 am    Post subject: Reply with quote

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
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